changing rollback segment initial extent

Hi all,

Problem: I need to increase the initial extent of serveral existing rollback segments. Since I cannot alter the initial extent of an existing rollback segment, I plan to do the following:

1. offline the rollback segment
2. drop the rollback segment
3. create a new rollback segment having the same name as the old rollback segment and with new values for initial and next extents
4. online this new rollback segment

I will need to perform this procedure on a live (production) database.

My questions: Do you see any potential problems with this plan? Faults? Especially concerning performance since this is a live database? I have 4 rollback segments in my database. I will apply this plan to each individual rollback segment one at a time. If this plan will not work, do you have any suggestions as to how I can change the initial extents on the rollback segments in a live database?

I am a newbie so thanks in advance for any suggestions and comments!!

Irene

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 29 2000 - 16:32:58 CDT