| 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: SQL Loader help
Rachel,
I do not claim to be a guru, but I do happen to have Jonathan's book here.
The first thing is what field type are you using for this memo field? The book says you should use CHAR for VARCHAR2, CHAR, LONG and other related.
What error are you getting?
Can you post the lines from the ctl?
Is there a chance there are TAB's in the data?
Stephen
>>> wisernet100_at_yahoo.com 08/29/03 09:24AM >>>
I know that there are several sql loader gurus on this list. I'm
having
a problem loading data from a third party vendor..... into what is
basically a LONG column
The file is ASCII, tab delimited. The specs on the input data say that this particular column is a "memo" field (the originating database is FoxPro.. joy)
I'm trying to load this into a 9.2.0.2 database. And it's barfing.
This
is annoying me no end and so I'm asking for help. I don't have
Jonathan's book here with me! (that would, of course, be easy)
Rachel
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: StephenAndert_at_firsthealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Aug 29 2003 - 13:19:27 CDT
 |
 |