Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase the size of the Rollback segment?

426951Apr 17 2006 — edited Apr 17 2006

Hi all,

Can I increase the size of a rollback segment while the segment in online and being used by a transaction?

Is the following command correct to do this?

ALTER ROLLBACK SEGMENT RBS_09
STORAGE(MAXEXTENTS unlimited)

Please reply.

Thanks in advance

Himanshu Dabir

Locked Post

New comments cannot be posted to this locked post.

Locked on May 15 2006

Added on Apr 17 2006

#general-database-discussions

2 comments

513 views