Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> How to use sqlldr to load a CSV file
I have a file containint fields separated by commas. I am trying to use oracle loader to populate a table.
Here is the control file I am trying to use:
LOAD INFILE myfile.csv
INTO TABLE USER.MYTABLE INSERT
FIELDS TERMINATED BY ','
This is an older parfile that worked for me about a year ago. What am
I missing here?
I have tried executing sqlldr as follows:
sqlldr user/pass control=myfile.par
Thanks for any help...
-Chuck Received on Fri Jul 27 2001 - 14:58:06 CDT
![]() |
![]() |