Re: Which rollback segment?

johns_at_adwyer.stx.com (Steve Johns) wrote:

>If an import is failing for lack of rollback space, must one single
>huge rollback segment be defined large enough to run the entire import
>transaction, or can the import use multiple RBS's whose total size is
>big enough?

I can't answer the former questions but only the latter. Unless you specify the COMMIT=Y import parameter, a commit will only be done after each object is imported. So your RBS would need to be big enough to handle a transaction the size of the largest object in the import file. With COMMIT=Y set in your import parameter file, a commit is done after each array insert.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Incoming fire has the right of way!