Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SQL Loader Problem

SQL Loader Problem

From: surendra tirumala <surendra_tirumala_at_rediffmail.com>
Date: 31 Aug 2000 21:08:24 -0000
Message-Id: <10605.116023@fatcity.com>


Dear all,
I am facing lot of problems in loading the data from flat files(generated from progress database) to Oracle 8i database. One of the columns in the data contains a text(maximum 4000 characters) which contains some formatted(carriage return keyssingle quotes ,double quotes etc..) data One of my friends helped me a lot in reaching out a near solution for this. I am facing difficulty when there is a huge data as I will have to do lot of formatting in the dat file. At present I am managing with the help of Sql Server(MS)'s DTS tool.But it is rejecting lot of records saying buffer size is small.I am not finding options to increase the buffer size.May be it is OS/Sql Sqrver related. I would like to know if any of you had problems in loading such data and how you overcome.Pl suggest me if there are any links or third party tools available. Your help is highly appreciated.

Suren
Oracle DBA,Entegram



Get Your Free Email At, http://www.rediffmail.com

Partcipate in crazy Re.1 auctions at http://www.rediff.com/auctions


 From: yong huang <yong321_at_yahoo.com>
 Date: Thu, 31 Aug 2000 14:52:15 -0700 (PDT)  Subject: ORA-22990: LOB locators cannot span transactions

While using SQL*Loader to load binary files into a BLOB column, I get the following error once. The sqlldr is run again and again in a loop in a shell Received on Thu Aug 31 2000 - 16:08:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US