Re: There is DDL statements which use rollback segments

Option 1:

    don't use 'alter table --- drop column' it's a bad idea.

Option 2:

    Use COMMIT 10000 to make the 'transaction' commit     after cleaning up every 10,000 rows. This will keep     Oracle switching rollback segments very 10,000 rows.     The drawback is that this encourages ORA-01555 on     any other long-running processes if the number of     rows in the table is very large.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Dmitry Rusakov wrote in message <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.

>

>

>