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

Home -> Community -> Usenet -> c.d.o.tools -> newbie needs help with SQL Loader

newbie needs help with SQL Loader

From: <_at_hotmail.com>
Date: Fri, 16 Feb 2001 19:56:30 GMT
Message-ID: <3A8D3381.33D7B9A9@hotmail.com>

Hello:

Here's my control file:

load data
infile 'test.txt'
into table excel

( Cusip  position(01:17)               char,
 Issuer_name  position(18:28)     char )

I get the following errors:

Record 11: Discarded - all columns null.
Record 12: Discarded - all columns null.
Record 13: Discarded - all columns null.
Record 1: Rejected - Error on table EXCEL. ORA-01400: cannot insert NULL into ("SCOTT"."EXCEL"."ISSUE_DATE")

Record 4: Rejected - Error on table EXCEL, column CUSIP. Column not found before end of logical record (use TRAILING NULLCOLS).

If I do 'not null' then I get errors saying 'syntax error....not null....."

Is the format 'test.txt' wrong? What other format can I use

Thanks so much,
SRC Received on Fri Feb 16 2001 - 13:56:30 CST

Original text of this message

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