how can I drop RB segment

From: Boris Bliznukov <blib_at_dnm.it>
Date: Sat, 11 Dec 1999 22:03:34 +0100
Message-ID: <3852BC26.F8314E1F@dnm.it>

Dear All,

Is there any way to drop damaged rollback segment or damadged tablespace ? Oracle is running with NOARCHIVELOG. Is there any way to recover those segments or drop it?

SVRMGR> select SEGMENT_NAME,TABLESPACE_NAME,STATUS from DBA_ROLLBACK_SEGS;

SEGMENT_NAME                   TABLESPACE_NAME                STATUS
------------------------------ ------------------------------
----------------
SYSTEM                         SYSTEM                         ONLINE
TMP_DDM_RBS02                  TMP_RBS                        NEEDS

RECOVERY
2 rows selected.
SVRMGR> commit;
Statement processed.
SVRMGR> set transaction use rollback segment system; Statement processed.
SVRMGR> drop rollback segment TMP_DDM_RBS02; drop rollback segment TMP_DDM_RBS02
*

ORA-01545: rollback segment 'TMP_DDM_RBS02' specified not available SVRMGR> drop tablespace TMP_RBS INCLUDING CONTENTS; drop tablespace TMP_RBS INCLUDING CONTENTS
*

ORA-01548: active rollback segment 'TMP_DDM_RBS02' found, terminate dropping tablespace
SVRMGR> --
*** "I always wanted to be somebody,

• but I should have been more specific."

Received on Sat Dec 11 1999 - 15:03:34 CST