Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Rowseparator in sqlldr?

Rowseparator in sqlldr?

From: Stefaan Blancke <Kristien.Stefaan_at_yucom.be>
Date: Thu, 31 Aug 2000 22:05:59 +0200
Message-ID: <hZQ3jb4EAHA.296@btbntsys4>

Hallo,

I'm trying to import data from a another database into Oracle, but I have problems when I want to import a LONG datatype(that contains multiple lines).How can I change the recordseparator. In SQL Server it is ROWSEPARATOR=...
Each record is separated with <END> /n and each column with <COL> From the moment you have a new line in the datafile Oracle sees it as a new record.
Does anybody have a solution?

Thanks,

Stefaan Received on Thu Aug 31 2000 - 15:05:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US