How about just committing every n rows, instead of trying to fit the
whole thing into one transaction? This is why they have the ROWS=
option on the command line and in the parameter file.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Sat, 15 Nov 2003, Stephane Faroult wrote:
> jaysingh1_at_optonline.net wrote:
> >
> > I have a problem loading data from flat file using SQL*Loader. The problem is unable to extend rollbacksegment. Is there a way to assign BIG rollback segment to SQL*Loader transaction? If not what is the work around to load huge volume of data without using TRUNCATE option?
>
> One work around might be to create a dedicated Oracle account with the
> suitable rights (INSERT on the table to load) and to use a login trigger
> to assign the rollback segment.
> Another, and probably much better, way would be to have several sessions
> running and parallel (and hopefully assign to different rollback
> segments by Oracle). If your volume of data is really big, chances are
> that you are loading into a partitioned table. If your input data had
> the good taste of being made of several files, each one destined to a
> separate partition, would be great. Perhaps some preprocessing is
> required. Otherwise split your data file, be certain to have several
> free lists to avoid contention, and there you go.
> You may have to play with constraints, this is usually the price to pay
> to do things in parallel.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremiah Wilton
INET: jwilton_at_speakeasy.net
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: 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 Sat Nov 15 2003 - 13:04:26 CST
