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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: need help with sql*loader problem

Re: need help with sql*loader problem

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Fri, 21 May 2004 20:31:46 -0400
Message-ID: <061801c43f94$2a1649f0$51a36244@ryan2le36ofjce>


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
> -----------------------------------------------------------------
>



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
-----------------------------------------------------------------
Received on Fri May 21 2004 - 19:29:01 CDT

Original text of this message

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