Add an explicit end-of-record string (or character) to your exported data
and tell sqlldr to use that instead of newline. Make sure you choose
something that doesn't occur in your data. It's not the most elegant way to
solve the problem but it works. As far as I could tell sqlldr doesn't have
any concept of something like \ to escape record or field terminators.
- James Moore
james_at_banshee.com
"Ira Rosen" <docnbydsgn_at_mediaone.net> wrote in message
news:38C1EEC7.96896B50_at_mediaone.net...
> 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 Mon Mar 06 2000 - 01:30:37 CST
