SQLLDR Problems loading text with carriage return & line feed characters
I've have be struggling for a few day on this one. I am converting a MS Access database to an Oracle8i database. Some of the text fields (MS data types, text and memo) contain carriage return and line feed characters (hex '0D' and '0A'). These characters are valid for the applications use, so they need to be retained. I've written some scripts to generate a control file using "BEGINDATA" to encapsulate the control information with the data for ease of execution. Everything loads correctly except these text instances. If I programmatically remove them (change x'0D0A' to x'20') all the data will load. This is not an isolated incident so the idea of having every development team manually alter their data after a load is not acceptable.
I tried inclosing these text fields using single quotes, double quotes and the "ENCLOSED BY" option. All efforts have failed. I would like to avoid writing a program just for this purpose. Any suggestions?
The question has also been posted in the "Oracle Text" forum on 08/21/2002.
Regards,
Jim Michalek
james.s.michalek@verizon.com