Re: cleaning up rollback segments

From: Graeme Farmer <g_farmer_at_halas.com.au>
Date: 2000/04/18
Message-ID: <xiWK4.3816$E4.7851@newsfeeds.bigpond.com>#1/1

If you don't beleive Sybrand, try taking it offline and it will tell you pretty quickly that you can't.

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:955946306.27787.0.pluto.d4ee154e_at_news.demon.nl...
> The system rollback segment is named SYSTEM in the SYSTEM tablespace.
> There's no such thing as a default R0 rollback segment.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Doug Cowles <dcowles_at_i84.net> schreef in berichtnieuws
> 38fa692d.18625480_at_news.remarq.com...
> > I've got a development database where the rollback segments were all
> > created in the SYSTEM tablespace. They were, SYSTEM, R0,
> > R01,R02,R03 & R04. I moved R01-4 into their own tablespaces.
> > However, I wasn't sure what to do with SYSTEM, and R0. Isn't R0 the
> > default system rollback segment? Or in this case is it SYSTEM?. How
> > do I know which rollback segment the database is using for it's SYSTEM
> > rollback segment? I could of sworn I've seen R0 ususally. Oracle
> > 8.1.5 on AIX. 4.3.2
> >
> > -Dc.
>
>
Received on Tue Apr 18 2000 - 00:00:00 CDT