Re: cleaning up rollback segments

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/17
Message-ID: <955946306.27787.0.pluto.d4ee154e@news.demon.nl>#1/1

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 Mon Apr 17 2000 - 00:00:00 CDT