-
I would like to create a SQL*Loader control file to import data from a comma delimited text file.
The data has to be imported into many tables and the tables have one to many relationship.
Eg: for one record in table X, I have many records in table Y and for one record in table Y, I have many records in table Z.
How should I format the text file?
What is the format for the SQL*Loader control file?
Thank you.
-
below is the general format of the control file:
+++++++++++
LOAD DATA
Infile [path & filename of .csv file]
DiscardMax
APPEND/INSERT/TRUNCATE
Into table [table name]
Fields Terminated By ',' OPTIONALLY ENCLOSED BY '"'
[Field names separated by commas]
+++++++++++
There are more parameters you can add to the control file. Visit the site below for more details.
http://technet.oracle.com/doc/server...ch03.htm#11662
leonard905
leonard905@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|