SQL*Loader with Embedded carriage returns
From: Ira Rosen <docnbydsgn_at_mediaone.net>
Date: Sat, 04 Mar 2000 23:21:11 -0600
Message-ID: <38C1EEC7.96896B50_at_mediaone.net>
[Quoted] I have a table that I'm importing into Oracle7 from MS Access. SQL*Loader handles all of my fields except one that contains embedded carriage returns. I am using tabs as a field delimiter. There are tab characters before and after the field in question in the input text file. Nonetheless, SQL*Loader gives errors with this field. Any suggestions regarding specificying the delimiter or terminator fields for such a field?
Date: Sat, 04 Mar 2000 23:21:11 -0600
Message-ID: <38C1EEC7.96896B50_at_mediaone.net>
[Quoted] I have a table that I'm importing into Oracle7 from MS Access. SQL*Loader handles all of my fields except one that contains embedded carriage returns. I am using tabs as a field delimiter. There are tab characters before and after the field in question in the input text file. Nonetheless, SQL*Loader gives errors with this field. Any suggestions regarding specificying the delimiter or terminator fields for such a field?
Thank you for your help.
-Ira Rosen
docnbydsgn_at_mediaone.net
Received on Sun Mar 05 2000 - 06:21:11 CET