Restrictions on Dropping Rollback Segments This statement is subject to the following restrictions:

You can drop a rollback segment only if it is offline. To determine whether a rollback segment is offline, query the data dictionary view DBA_ROLLBACK_SEGS. Offline rollback segments have the value AVAILABLE in the STATUS column. You can take a rollback segment offline with the OFFLINE clause of the ALTERROLLBACKSEGMENT statement.