Sql*loader

[Guest_imported]

Hello, I have a concern with the loading of files comprising a carriage return at the end of each line.
Has-it an option or another solution to charge my files with sql*loader with oracle 8.1.16.
For the moment they are systematically rejected with the loading. Thank you in advance

Sidi

 

[rtefft]

3 options come to mind:

1. In your control file, specify OPTIONALLY TERMIATED BY X'D' . This tells is that a CR (D in hex) may terminate some fields, so it will ignore the character itself. Look in the Oracle8i Utilities guide for details.

2. Is it possible that the CR resulted from an incorrect FTP transfer? If you FTP a text file using Binary mode instead of ASCII, you end up with a CR character imbedded at the end of each line. If this may be the cause, try transferring the original file using ASCII.

3. Another option would be to strip the CRs out of the data file using a search-and-replace in an editor, or write a simple PL/SQL widget using UTL_FILE to strip the characters out. If you're using unix, the VI editor can handle very large files with ease.

Hope one of these helps,
Rich ____________________________
Rich Tefft
PL/SQL Programmer