Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: SQL Loader / Loading big text fields Date: Mon, 08 Sep 2003 20:57:24 -0700 Organization: ATS Message-ID: <1063079825.724406@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <3345587.1063064351@dbforums.com> <3345889.1063069954@dbforums.com> In-Reply-To: <3345889.1063069954@dbforums.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@pond178.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 57 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82883 jbroder wrote: >Thanks your reply. > > > >My oracle version is: > >Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production > > > >My table looks like this: > > > > ----------------------------------------- -------- ---------------------------- > > DOC_SECTION_HEADING VARCHAR2(150) > > DOC_ID NUMBER(11) > > DOC_SECTION_ID NOT NULL NUMBER(11) > > DOC_SECTION_TEXT VARCHAR2(4000) > > > > > > > >I am, unfortunately, still have problems. > > >-- >Posted via http://dbforums.com > > Please send me the DDL for the table and a small dataset sample to test. I'd like to try to duplicate this on one of my servers. Darn ... one thing just occured to me. Often this is caused by missing carriage returns. What appears to be multiple rows to the human eye (line feed), is to the computer, a single extremely large record. Copy a portion of the file that won't load into something dumb like notepad and try resizing the width of the window or examine it with a byte editor. You may well have, from the computer's standpoint, a much larger record than you think. -- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply)