Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader with Embedded carriage returns

SQL*Loader with Embedded carriage returns

From: Ira Rosen <docnbydsgn_at_mediaone.net>
Date: 2000/03/04
Message-ID: <38C1EEC7.96896B50@mediaone.net>#1/1

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 Sat Mar 04 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US