| How to load flatfile into Oracle [message #69405] |
Mon, 24 December 2001 13:56  |
kim
Messages: 116
Registered: December 2001
|
Senior Member |
|
|
1. I haveve a flatfile that is to be loaded into Table1, Table2. Please give a skeleton sample how to do this.
2. Also at the same, I would like to generate unique key when i load also. Any sample would appreciate.
thanks,
kim
----------------------------------------------------------------------
|
|
|
|
| Re: How to load flatfile into Oracle [message #69410 is a reply to message #69405] |
Wed, 26 December 2001 00:19  |
Somu
Messages: 24
Registered: February 2000
|
Junior Member |
|
|
Hi,
You can use SQLLOADER to do this job. you will get the sample control files from the oracle server directory, find out the sample files and load the files into the table.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
