Re: changing rollback segment initial extent

What you planed is right. You can go ahead with that. Only thing you have to take care is while making offline drop just make sure its become offline. Becoz it will take some time to become offline since its used online.

Jeeju

In article <8oha6a$9u7$1_at_nnrp1.deja.com>,   irenekam_at_my-deja.com wrote:
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 30 2000 - 06:12:13 CDT