Re: how can I drop RB segment

Mark Wagner wrote:

> 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......

I tried this one ... does not help a lot. Segment is in 'NEEDS RECOVEY' state and my guess I cannot do anything with it. And I can not recover it since NOARCHIVE option ..

SVRMGR> alter rollback segment TMP_DDM_RBS02 offline; alter rollback segment TMP_DDM_RBS02 offline *
ORA-01598: rollback segment 'TMP_DDM_RBS02' is not online SVRMGR>
> Ill check back on monday from work and see if you have the answer

Thanks a lot fo replay.

> 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 Sun Dec 12 1999 - 04:33:59 CST