Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to use sqlldr to load a CSV file

How to use sqlldr to load a CSV file

From: Chuck Carson <chuckc_at_clinicomp.com>
Date: Fri, 27 Jul 2001 19:58:06 GMT
Message-ID: <3b61c7be.12589502@news.qwest.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US