How to load newlines with SQL*Loader direct?
From: Anatol <azsi_at_my-dejanews.com>
Date: Thu, 06 May 1999 05:10:38 GMT
Message-ID: <7gr88c$1lt$1_at_nnrp1.deja.com>
[Quoted] I'm looking for help with the following predicament:
Date: Thu, 06 May 1999 05:10:38 GMT
Message-ID: <7gr88c$1lt$1_at_nnrp1.deja.com>
[Quoted] I'm looking for help with the following predicament:
[Quoted] some values that I need to load into an Oracle 8 DB have newlines (\n, chr(10), that thing...) inside them, which need to be preserved. How do I tell the SQL*Loader to do that? I would like it to work in direct, rather than SQL mode, because the data volume is rather substantial.
[Quoted] I did manage to make the SQL*Loader _ignore_ the newlines ( by using "OPTIONALLY DELIMITED BY" clause), but in that case it just concatenated the two lines. I need the newlines to be loaded into the DB, not ignored.
Thanks in advance,
-- [Quoted] Anatol Zolotusky anatol_at_itn.net az1_at_best.com -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Thu May 06 1999 - 07:10:38 CEST