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
[EMAIL PROTECTED] wrote:
>
> Dear Gurus,
>
> 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
>
Dear Gurus,
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?
Thanks