Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Loader and rollback segment

Re: SQL*Loader and rollback segment

From: Jeremiah Wilton <>
Date: Sat, 15 Nov 2003 11:04:26 -0800
Message-ID: <>

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

On Sat, 15 Nov 2003, Stephane Faroult wrote:

> 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: -- Author: Jeremiah Wilton INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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

Original text of this message