Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Leading NULL values for SQLLoader80-Import not excepted?
"Frank" <fvanbortel_at_netscape.net> schrieb im Newsbeitrag
news:3E3ED779.5020509_at_netscape.net...
> Marc Heravi wrote:
> > Hi,
> >
> > when trying to load TAB-delimited data into a table using sqlldr80 into
> > oracle 8.0.5.0.0
> > the lines that contain leading null values lead me to error message
> > ORA-01401 with the log file attached below.
> >
> > Question: How can i make the oracle database/sqlloader ACCEPT those
leading
> > null values?
> > DDL:
> > CREATE TABLE SF_VORNAME (
> > GESCHLECHT varchar2 (1) NULL ,
> > VORNAME varchar2 (50) NULL ,
> > TIMES varchar2 (25) NULL
> > );
> >
> > Auszug aus dem Logfile:
> > Spalte GESCHLECHT NULL wenn GESCHLECHT = BLANKS
> >
> > Satz 3: Abgelehnt - Fehler in Tabelle SF_VORNAME.
> > ORA-01401: Eingefügter Wert zu groß für Spalte
>
> Viellicht GESCHLECHT NULL wenn GESCHLECHT = '' ?
>
I tried several options to try and get the right result: TRAILING NULLCOLS (this should have been the right choice)
NULLIF column = BLANKS NULLIF column = ' ' NULLIF column = X'09' (for the delimiter only)
None of that nor combinations of them worked... IMO DBMS should NEVER decide about what to import and not! Reason: Its behaviour becomes inconsistent, in case you import data by commandline-importer or sql-statements (insert into SF_VORNAME (null,null,null) works fine but thats not a real solution!)
Thanks you Frank, still trying and hoping... Marc. Received on Tue Feb 04 2003 - 02:32:15 CST