how to user sqlldr in this case.
Date: Wed, 1 Sep 2004 11:13:51 +0000 (UTC)
[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.
INTO TABLE mytable
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,
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Sep 01 2004 - 13:13:51 CEST