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: > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).