Re: specifying rollback space w/SQLLDR

From: Jerry Gitomer <>
Date: Thu, 5 Aug 1999 14:30:49 -0400
Message-ID: <7oek55$c26$>

Would it be viable for you to use SQL*Loader's default of committing every 64 records? If not, can you use the rows=<n> option (where <n> is the number of records to commit at a time) in order to allow SQL*Loader to run using your smaller rollback segments.

Jerry Gitomer wrote in message
>I am interested in finding out if anyone know how
>to specify a specific rollback segment when
>running sqlldr. I have 10 rollback segments with
>9 of them average sized and one very large. I
>have 2 tables that will not load using the 9
>average sized rollback segments. To my
>understanding, the rollback segment is selected
>based upon whatever is available. Therefore
>hitting the large rollback segment is unlikely.
>I would appreciate any suggestions.
>Sent via
>Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 20:30:49 CEST

Original text of this message