Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Rowseparator in sqlldr?
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
![]() |
![]() |