Re: Row Terminator in SQL*Loader

From: Peter Giannopoulos <petergi_at_generation.net>
Date: Fri, 31 Jul 1998 15:30:02 -0400
Message-ID: <35C21B3A.FD335052@generation.net>

I'm having the same problem, and would like to know as well when you find out.
Also what oracle datatype did you choose to store the data from and SQL Server text field?

Thanks.

Shalabh Bhatnagar wrote:
>
> Hi Anybody,
>
> I have to load large memo field(s) data from SQL Server to Oracle 7.3
> these memo fields have all sorts of character in them including linefeed
> and carriage return. When SQL Server exports the data, one can specify a
> ROW TERMINATOR.
>
> How can we specify ROW TERMINATOR in .CTL file of SQL*LOADER.
>
> If SQL*LOADER does not have concept of row terminator, then how does one
> load large text fields with linefeed and carriage returns.
>
> Thanks

--

---

"Do not look to authority for truth - look to truth for authority." Yoshida Kenji Sensei - Yanagi Ryu Aiki Bugei

Peter Giannopoulos
generation.net
Database & Web Applications Developer

Ph: 514-845-5555 ext.218
Fax: 514-845-5004
ICQ# 1723017

---

Received on Fri Jul 31 1998 - 14:30:02 CDT