Rollback Segment Status 'PENDING OFFLINE'

From: Arthur Chung <arthur.chung_at_interactive.rnb.com>
Date: Thu, 10 Dec 1998 15:47:21 -0500
Message-ID: <36703359.6B5CB8E7@interactive.rnb.com>

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 Thu Dec 10 1998 - 14:47:21 CST