Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL*Loader Question?
Greetings,
I was trying to load about 120 rows of data with the delimiter '%' using the following control file:
LOAD DATA INFILE 'C:\1.txt' BADFILE 'C:\1.BAD' DISCARDFILE 'C:\1.DIS' INSERT INTO TABLE FILE FIELDS TERMINATED BY '%' TRAILING NULLCOLS ( col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11)
And the file containing the data is as follows
NAME1 % NAME2 % NAME3 % DOB % ADDRESS % CITY % STATE % ZIP % PHONE_NO % SSN %COMMENTS I have the following questions:
I tried with just one row and still the same problem occurs. Also all the fields in the Oracle database table is varchar2. Any suggestions would be very greatly appreciated.
Thanks in advance
Vishwa
vishu2_at_hotmail.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Apr 20 1999 - 23:39:12 CDT