Re: specifying rollback space w/SQLLDR

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.

regards
Jerry Gitomer

kcmarrs_at_my-deja.com wrote in message
<7oci3p$kn9$1_at_nnrp1.deja.com>...
>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 Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Aug 05 1999 - 20:30:49 CEST