Re: Rollback Segment Status 'PENDING OFFLINE'

You can try to put a line in your init.ora. '_offline_rollback_segment' r07

Then shut down Oracle and then drop the rollback segment.

The 'offline_rollback_segment' ask Oracle not using r07 when restart Oracle. This way, you can drop the rollback segment and drop the rollback tablespace if you like.

Good Luck

Alex Cheung (alexcheung_at_onramp.ca)

>I'm running Oracle 8.0.4 on Solaris 2.6 env.
>
>One of the rollback space has gotten status FULL and I wanted to bring
>it down ( I wanted to drop that rollback space ).
>
>When I gave the command, 'alter rollback segment r07 offline',
>instead of going offline directly, status changed to 'PENDING OFFLINE'
>... so far so good...
>but it stayed that way for many hours.. and I don't think it will ever
>change.
>
>I did shutdown the database properly but it comes backup clean to ONLINE
>status and whenever I try to take it offline, I again get same 'PENDING
>OFFLINE'.
>
>What could be the issue that's holding this up?
>Is there any way to force the system so that rollback space goes to
>OFFLINE status?
>
>Any info would be appreciated!
>-Arthur
>
>
Received on Sat Dec 12 1998 - 22:09:32 CST