Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need 1st time help with SQL Loader...
In article <X6970424142846_at_lasher>,
kgrigg_at_acxiom.com (Kelly) wrote:
>Hello all!!
>
>I am trying to understand how to load a Personal Oracle 7.3 database via
>SQL Loader. I have the database up and running, SQL net, etc. I have
>created a simple table called JOETABLE. It has 3 fields: FNAME char 10,
>LNAME char10 and ADDRESS char 50. I have a joe.ctl file with the following:
>
>
>LOAD DATA INFILE 'joe.dat' INSERT INTO TABLE JOETABLE FIELDS TERMINATED BY
>"," OPTIONALLY ENCLOSED BY '"'
>( "FNAME" CHAR(10),
> "LNAME" CHAR(10),
> "ADDRESS" CHAR(50))
>
>
>
>The data file (joe.dat) looks like this:
>
>
>"FNAME","LNAME","ADDRESS"
>"Kelly","Grigg","AR"
>"Lester","Tester","TX"
>"Chris","Suttle","state"
>
>
>
>When I try to run imp kgrigg/kgrigg parfile=c:\temp\joe.ctl
>
>I get the following errors,
>
>LCC-00113: integer conversion error or negative integer [DATA] LCC-00218:
>error in file [c:\temp\joe.ctl] LCC-00217: failure while processing file
>parameter [parfile]
>
>and a couple of IMP-##### errors dealing with import terminating. Can
>anyone give me some pointers or tell me where to look for some more
>literature on the syntax I should be using?
>
>By the way, the joe.dat file is also in c:\temp directory...I have tried
>putting the whole path in the INFILE, as a matter of fact, I have tried
>many different variations of the above and still get the same error
>messages.
>
>Any/All help appreciated!!
>
>TIA,
>
>Kelly kgrigg_at_acxiom.com
>
>
>
Hi Kelly,
You are trying to use the IMPORT utility command imp
Try SQLLDR !
Regards
Frank Received on Tue Apr 29 1997 - 00:00:00 CDT