Home » RDBMS Server » Server Utilities » Re: Urgent!!! SQL * LOADER Question
Re: Urgent!!! SQL * LOADER Question [message #69030] Wed, 17 October 2001 10:51
Chayan
Messages: 2
Registered: October 2001
Junior Member
The legacy (email history) data is imported into a text file. The body of the email has new line characters. But, when I am using SQL Loader, it is recognizing each new line character as a new record and splitting up each record.

How I can separate the records and keep the email body intact? Is there any special syntax that I can use to specify new line character in SQL Loader? How can I override the default end of record, which is the new line character?

Thanks!

----------------------------------------------------------------------
Previous Topic: sequence numbers skipped when records are rejected during a load
Next Topic: Re: importing data from excel to oracle tabel???
Goto Forum:
  


Current Time: Tue Apr 23 14:54:31 CDT 2024