Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQLLoader and CR/LF in data
Is there any way to import files containing CR/LF in the data?
We are looking at converting a lot of data from SQLServer to Oracle, and this seems to be the only sticky point.
Does SQLLoader have any way to indicate that the row terminator is anything besides CR/LF?
If not, does anyone have scripts already written to handle this case?
It seems as if you can export via bcp using some high ascii row terminator, change the CR/LFs to a different high ascii and then change the row terminator to CR/LF, import the data, then update the data in the database to change the high ascii value back to CR/LF.
Besides being a royal pain, the above may be too slow as the final conversion will require taking the applications off line for as long as the process takes. For repeatability & reliability the conversion process needs to be automated, so using a third party utility such as WinSQL that can move one table at a time is not an option. Any utility that can be run completely from the command line would be fine. Received on Mon Feb 01 1999 - 18:13:50 CST