SQL Loader

[Quoted] I am attempting to load ASCII data files (created from SQL server using bulk [Quoted]  copy) into an oracle (v8.0) database. The problem is with long datatypes - [Quoted]  some contain carriage returns so the loader assumes that the record is  finished when it is not. The data file is tab delimited, and the long  datatypes are of variable length. I am using a DOS system so the "VAR"  option does not appear to help - and anyway, I need to use specify trailing [Quoted]  nulcolls. It is not possible to enclose the offending datatypes in quotes  and I need to preserve the carriage returns in the datatypes. I have no idea [Quoted]  what characters will in the future be found in the datatypes so inserting a [Quoted]  dummy character to mark a carriage return and then later using SQL to  re-insert the carriage return is risky. Do you have any suggestions of how [Quoted]  to overcome this problem?   

Thanks! Received on Fri Feb 21 2003 - 12:00:17 CET