Re: There is DDL statements which use rollback segments

DDL commands imply a DML on the data dictionary tables (such as Used and Free Extents -UET$ and FET$), unless you are using locally managed tablespaces -which is thoroughly recommended.

Never thought about it -but I'll make a small bet that it's your SYSTEM rollback segment which is ballooning in size when you do these sorts of transactions. And since it's the data dictionary tables that are being adjusted (which are, of course, in the SYSTEM tablespace), there's sod all you can do about it, except make your SYSTEM rollback segment much larger before doing a mammoth drop column operation (heaps of 'allocate extent' springs to mind), and then a lot of shrinking afterwards.

I'd be interested to know how many extents you've got for these tables before you begin?
Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



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

>

>

>