Re: how can I drop RB segment

I believe that before you can drop a rollback segment you have to take it offline.....

Not sure how to take offline.... and all my books are at work......

Ill check back on monday from work and see if you have the answer

Mark

Boris Bliznukov wrote in message <3852BC26.F8314E1F_at_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 Wed Dec 08 1999 - 01:01:54 CST