Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> [Q] sql loader problem while load record more than one line???
We are migrate from MS Access to ORACLE(9.2.0.4) use
SQL*Loader. The problem we have are some of MS Access
dump records (ASCII output) have to several lines(EOL
before end of record). For example:
control file:
load data
infile 'data.asc'
into table test
fields terminated by ','optionally enclosed by '"'
TRAILING NULLCOLS
(
ID,
comment
)
Data.asc file:
"101", "September 1, 2003 - Labor Day
November 27, 2003 - Thanksgiving Day November 28, 2003 - Day after Thanksgiving December 24, 2003 - Christmas Eve December 25, 2003 - Christmas Day
Does there has way to pass around?
Thanks.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: dba1 mcc INET: mccdba1_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Thu Jan 29 2004 - 09:34:27 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).