Re: There is DDL statements which use rollback segments

From: Grzegorz Dryl <Grzegorz.Dryl_at_crt.tpsa.pl>
Date: Tue, 3 Oct 2000 14:07:59 +0100
Message-ID: <8rci06$dis$1@news.tpi.pl>

U¿ytkownik "Dmitry Rusakov" <r_d_a_at_chat.ru> napisa³ w wiadomo¶ci news:8rcf9m$2bai$1_at_storm.comstar.ru...
> such as alter table ... drop column. I'm see rollback segment size
> increasing while processing this DDL. I get message about impossibility
> rollback size increasing.

if associating rollback segments does not work with ddl, do as follows

- create "BIG" rollback segment
- take offline other rollback segments
- execute query
- take online other rollback segments
- drop "BIG" rollback segments

Received on Tue Oct 03 2000 - 08:07:59 CDT