how to user sqlldr in this case.
From: Yang Lee <yang__lee_at_ausi.com>
Date: Wed, 1 Sep 2004 11:13:51 +0000 (UTC)
Message-ID: <d2e9d8b6e9dc6eaadd37919ecc3475f1.93862_at_mygate.mailgate.org>
Hi all,
[Quoted] I have a huge data in a text file.
10 123r closed 67 90
Date: Wed, 1 Sep 2004 11:13:51 +0000 (UTC)
Message-ID: <d2e9d8b6e9dc6eaadd37919ecc3475f1.93862_at_mygate.mailgate.org>
Hi all,
[Quoted] I have a huge data in a text file.
10 12223 closed 647 90
10 90 10 67 90 10 12a closed
10 123r closed 67 90
each field is separated by a tab and each field is of different length.
and many fields as you see are NULL.
Now I want to use sqlldr.exe
to load the data in my table I use following
control file WITH my text data file renamed as etc.dat.
LOAD DATA
INFILE 'etc.dat'
BADFILE 'sample.bad'
DISCARDFILE 'sample.dsc'
APPEND
INTO TABLE mytable
TRAILING NULLCOLS
(
fname INTEGER TERMINATED BY " " NULLIF mname=BLANKS ,
mname CHAR TERMINATED BY " " NULLIF mname=BLANKS ,
lname CHAR TERMINATED BY WHITESPACE,
gname CHAR TERMINATED BY WHITESPACE,
hname INTEGER TERMINATED BY WHITESPACE,
)
it doesn't solve the purpose. please provide me correct control file.
Thanks a lot in advance,
Lee
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Sep 01 2004 - 13:13:51 CEST