Re: Rollback Seg problem.

Did all of these things. It ends up with one segment with a PENDING OFFLINE status. Because it never actually gets offline, I can't drop the rollback segment.

Michael.

Fang Hu wrote:
>
> 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 - 15:11:26 CDT