Re: HELP! Disabling Rollback Segments

Mark Kimball wrote on 06-Apr-99 19:54:09:
>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.

Hello Mark,
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

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |