I have a flat file with Varchar2 data spread across lines with carriage return..
I have tried using the following but in vain.
=================================
LOAD DATA
INFILE 'test.dat' "str X'0c0a'"
INTO TABLE arul.test1
FIELDS TERMINATED BY "~" optionally enclosed by '"'
trailing nullcols
(
no ,
descr
)
=================================
where descr - Varchar2(4000) field..
There is no error message(!)??
Note - With the above spec. able to load only the first record with carriage returns embedded. Rest of the records are skipped as bad records(!) .
Can anyone suggest the ways of loading it thru SQL Loader?
Thank you.
regards,
Arul.
*********************************************************
Disclaimer
This message (including any attachments) contains
confidential information intended for a specific
individual and purpose, and is protected by law.
If you are not the intended recipient, you should
delete this message and are hereby notified that
any disclosure, copying, or distribution of this
message, or the taking of any action based on it,
is strictly prohibited.
*********************************************************
Visit us at http://www.mahindrabt.com
