Re: SQL*LOADER problem

From: <Diana_Duncan_at_ttpartners.com>
Date: Wed, 30 May 2001 19:11:07 -0700
Message-ID: <F001.00314EB2.20010530185023@fatcity.com>

Satish,

You can do a couple of things...in the query you could to a replace(column1, chr(10), '~') (or some other unlikely character or string), then do a replace again in the SQL*Loader script to get the carriage returns back in there. Or you could use the query to put a character in the front of each true record, something like

select '#' || col1, col2, col3, ....

and then use the SQL*Loader commands for concatenating records. Can't remember offhand how that one works, though...

HTH, Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: Diana_Duncan_at_ttpartners.com

                                                                                       
                                   
                    "Satish Iyer"                                                      
                                   
                    <Satish.Iyer_at_ci.seat        To:     Multiple recipients of list 
ORACLE-L <ORACLE-L_at_fatcity.com>       
                    tle.wa.us>                  cc:                                    
                                   
                    Sent by:                    Fax to:                                
                                   
                    root_at_fatcity.com            Subject:     SQL*LOADER problem        
                                   
                                                                                       
                                   
                                                                                       
                                   
                    05/30/2001 08:05 PM                                                
                                   
                    Please respond to                                                  
                                   
                    ORACLE-L                                                           
                                   
                                                                                       
                                   
                                                                                       
                                   

Hi everyone.
Having this typical problem with sql*loader. I am extracting data out from a table and this table has a field in which users have put in a new line feed character. Now when I extract the data out using SQL*PLUS it obviously has a problem
eg.

1 First line of stt 2333232

     Second line
2    Full line           2323232
3   Again a partial  2323232
     line.

Now if such a table was extracted to a txt file, the sqlldr runs into a problem of getting the second half of the line as expected. Any ideas how this could be avoided ?
Hope I explained that okay.

Satish Iyer
DBA
CCSS Team 684-3016

--

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

Author:
  INET: Diana_Duncan_at_ttpartners.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed May 30 2001 - 21:11:07 CDT