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 >>> [EMAIL PROTECTED] 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 __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).