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

You may want to add CONTINUEIF clause and try the load again

...
infile 'data.asc'
CONTINUEIF NEXT (1) != '"'
into table test
...

For complete reference, see this URL:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/ch05.htm#1005518

-- 
Thanks,
Krishna

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
NOTICE:  This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information.  Any unauthorized review, use, disclosure or
distribution is prohibited.  If you are not the intended
recipient, please contact the sender by reply email and destroy
all copies of the original message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


dba1 mcc wrote:


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

> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Krishna Kakatur
  INET: Krishna.Kakatur_at_Sun.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).