Database Administration (MOSC)

MOSC Banner

When trying to delete the undo tablespace, getting the following error.

edited Aug 31, 2018 5:05AM in Database Administration (MOSC) 7 commentsAnswered

When trying to delete the undotablespace, getting the following error.
Drop tablespace UNDOTBS1 including contents and datafiles
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU10_4058727488$' found, terminate
dropping tablespace

Also tried to drop the roll back segment and it fails with the following error:

drop rollback segment "_SYSSMU10_4058727488$"
*
ERROR at line 1:
ORA-30025: DROP segment '_SYSSMU10_4058727488$' (in undo tablespace) not
allowed


Checked the status of the rollback and the status is needs recovery.
select segment_name,status,tablespace_name from dba_rollback_segs where status not in ('ONLINE', 'OFFLINE') ;

SEGMENT_NAME STATUS TABLESPACE_NAME
------------------------------ ---------------- ------------------------------
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center