Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: need help with sql*loader problem
this may be slow.... but could you make an external table? and use pl/sql
to insert it into a table with code? sqlloader is not very robust.
btw, isn't it possible to expert access data directly to a file in comma
delimited form without using an external tool?
----- Original Message -----
From: "david wendelken" <davewendelken_at_earthlink.net>
To: <oracle-l_at_freelists.org>
Sent: Friday, May 21, 2004 4:57 PM
Subject: need help with sql*loader problem
>
>
> I'm trying to export data out of Access into Oracle.
>
> My predecessor on the project had used the Oracle Migration workbench to
do it, but it replaced characters like " with ?. Haven't figured out how to
tell it not to do that.
>
> So, I set up some sql loader control files and exported the data from
Access into csv files.
>
> Unfortunately, the access data has carriage returns in the long textual
data fields, so instead of one line per record, I get lots of lines per
record. Sql*Loader is interpreting each line as a new record.
> I've told it to use " as terminators and , as delimiters, but those
settings are "per field" not "per record.
>
> Also, both of those characters are present in the textual data, which may
be causing other problems.
>
> Any ideas on how to get past all of this?
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri May 21 2004 - 19:29:01 CDT