How to disable the rollback segment?

We are currently building a data warehouse and have had problems with
loading data due to the rollback segments. We keep getting errors that the
rollback segments need to be extended when it appears they are big enough.
We have 2 rollback segments at 300M each. Is it possible to take the
rollback segments offline when loading and bring them back online after the
load it complete? Thank you for any help you can provide.

Ans1:

How are you loading the data? Can you use the direct=true mode of the sqlldr
tool? If so, you can in fact bypass both redo and undo (if the database is in
noarchivelog mode).

Can you give us more info about exactly how you are loading the data?

Ans2:

AFAIK you cannot disable every rollback segment before loading because the
loading needs some rollback information.
I experienced Oracle creating rollback information much larger than the
data being loaded. So you might increase the size of your rollback
segments.
Annother option is to use direct path load with the unrecoverable option.
This way only minimal rollback information is written.

Hope that helps,
Lothar

Hosted by www.Geocities.ws