When trying to delete the undo tablespace, getting the following error.
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:
0