Stephen, I was using CHAR for the LONG column.... the error is actually on the field in the file FOLLOWING the LONG column... I was getting a message that the data was too large. So I did the following and it seems to be working, although I can't get it to work via direct path this way:
I changed the column in the Oracle table to CLOB I changed the definition of the column in the ctl file to char(100000000) The column separator was X'001' and the end of record marker was X'002'. I had been translating them both, the 001 to a tab and the 002 to a newline. I translate only the end of record marker now and define the column separator as X'1' in the ctl file. So far, it's working. Of course, it's slow as molasses, and this is a column which we DON'T NEED but then again... it's the Friday before a long weekend. I just want to get it to work, I'll make it pretty and fast later Rachel --- Stephen Andert <[EMAIL PROTECTED]> wrote: > 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). __________________________________ 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).
