Re: need help with sql*loader problem
- From: "Ryan" <ryan.gaffuri@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 May 2004 20:31:46 -0400
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@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
