sqlldr .txt to oracle table

[joyloce]

dear all:
I face such issue:
user upload the .txt from different platform server to my database server, the text file include columns name , how can I write the sqlldr control file : unsqlldr the columns name just as the first row and the fields seperate by tab .

B.Regards and Thanks
joyloce

[nagarjuna]

Oracle documentation => Oracle8i Server and SQL*Plus, Release 8.1.7 => Oracle8i Utilities => SQL*LOADER

[joyloce]

Originally posted by nagarjuna
Oracle documentation => Oracle8i Server and SQL*Plus, Release 8.1.7 => Oracle8i Utilities => SQL*LOADER

dear nagarjuna :

would you tell me clear!

thank u ....

joyloce

[nagarjuna]

Carete your own cfile using the following example.


LOAD data
INFILE '<<.csv file name>>'
INTO TABLE <> FIELDS TERMINATED BY '|'
(col1 ,col2,col3)

This is just an examle. Your .csv file should be "," separated I guess. so, use the TERMINATED BY ',' clause. And change others fileds according to your table structure.


and the things I given in my prevous post point to the sql*loader documentation.