Re: Rollback Seg problem.

1. Use command: select segment_name, tablespace_name, status from dba_rollback_segs; to get information about the rollback segment you want to dropped. If it is online you should alter it offline.
2. alter rollback segment rollback_segment_name offline.
3. drop (private or public) rollback segment rollback_segment_name.

Frank

Michael Rothwell <michael_rothwell_at_non-hp-usa-om46.om.hp.com> wrote in article <35C9D081.23B35A3A_at_non-hp-usa-om46.om.hp.com>...
> I get an error on a file being corrupt. I traced the file
> down to the file that the rollback segment is in. I created
> a new rollback seg and placed it on line, shut down the db
> and restarted it. I am trying to drop the old rollback seg
> but it is still being used. I tried to start the db without
> mounting/opening. I still could not drop the rollback seg.
> What do I need to do.
> This is a test system, so it's not mission critical.
>
> NT 4.0 box
> RDBMS 7.3.x
>
> Thanks.
>
> Michael.
>
Received on Thu Aug 06 1998 - 11:18:36 CDT