| 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 Problem
Have you altered parameters on the command line like "rows=400
bindsize=10000000 "?
They will help, espec. in performance. (bindsize has a hard limit of
10000000. The two parameters have to be coordinated by row size of data).
I like the idea of a reformatting of the text itself. Carriage returns in
the data etc.
is a bad idea.
Akshay Jain
-----Original Message-----
From: surendra tirumala [mailto:surendra_tirumala_at_rediffmail.com]
Sent: Thursday, August 31, 2000 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject: SQL Loader Problem
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
Partcipate in crazy Re.1 auctions at http://www.rediff.com/auctions
-- Author: surendra tirumala INET: surendra_tirumala_at_rediffmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Sep 01 2000 - 08:35:51 CDT
 |
 |