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

From: Nikhil Khimani <nkhimani_at_marketaxess.com>
Date: Thu, 29 Jan 2004 07:54:25 -0800
Message-ID: <F001.005DE5D8.20040129075425@fatcity.com>

This is a hack but ... you might want to look into ftp-ing a file to Unix, run a 'tr' or 'sed' to get rid of the EOL character.

Thanks,  

Nikhil

-----Original Message-----
Sent: Thursday, January 29, 2004 10:34 AM To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nikhil Khimani
  INET: nkhimani_at_marketaxess.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:54:25 CST