There are no hopes to load a datafile like this in a reliable manner, unless
you replace the embedded control characters with substitution strings like
"{cr}{lf}" or "{newline}". Then, upon loading, they will be re-replaced by
their actual counterparts by means of SQL functions specified in the control
file like "REPLACE(:column_name, '{newline}', chr(13) || chr(10))".
This method works well, unfortunately this prevents you from using the
Direct Path loading option and forces you to manipulate the source file for
substituting control characters unless you defer character substitution to a
later stage, probably staging the data in some temporary table where you can
manipulate data more easily.
Bye,
Flavio
Received on Thu May 01 2003 - 03:42:28 CDT
