[Q] sql loader problem while load record more than one line???

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 29 Jan 2004 07:34:27 -0800
Message-ID: <F001.005DE5D6.20040129073427@fatcity.com>

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

January 1, 2004 - New Year's Day
January 19, 2004 - Martin Luther Ki"

Does there has way to pass around?

Thanks.

---

Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it! http://webhosting.yahoo.com/ps/sb/

-- 
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-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Jan 29 2004 - 09:34:27 CST