Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Leading NULL values for SQLLoader80-Import not accepted?
"Marc Heravi" <marcsimone_at_arcor.de> schrieb im Newsbeitrag
news:3e3f7a8e$0$9808$9b4e6d93_at_newsread4.arcor-online.net...
>
> "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?
> > 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)
>
Solved: Should not have used OPTIONALLY ENCLOSED BY '"'-Clause together with FIELDS TERMINATED BY X'09' to import Tab-delimited data.
(sorry for not supplying a control-file, hey, i'm nearly happy again ;-) Marc. Received on Tue Feb 04 2003 - 09:55:08 CST