Re: how can I drop RB segment

Try setting the tablepspace and/or the rollback segment offline and then drop it.
alter rollback segment TMP_DDM_RBS02 OFFLINE; alter tablespace TMP_RBS OFFLINE;
drop tablespace TMP_RBS including contents;

Hope this works
Andy

Boris Bliznukov schrieb:

> 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 Mon Dec 13 1999 - 08:32:01 CST