| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: need help with sql*loader problem
If you can, try ftp'ing the file to UNIX and try 'tr' command with -s
option. Might get you past the hump ...
Thanks,
Nikhil Khimani
Market Axess
140 Broadway, 42nd Floor
New York, NY 10005
(212) 813-6230 (W)
nkhimani_at_marketaxess.com
-----Original Message-----
From: david wendelken [mailto:davewendelken_at_earthlink.net]
Sent: Friday, May 21, 2004 4:57 PM
To: oracle-l_at_freelists.org
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?
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |