Re: cleaning up rollback segments

Oh I believe Sybrand.. I think the reason for my confusion might be that in the evironment I'm in usually creates a R0 in the system tablespace owned by system... Sybrand answers 90% of my questions as it is. Have no reason to doubt now..

• Dc.

On Tue, 18 Apr 2000 20:00:32 +1000, "Graeme Farmer" <g_farmer_at_halas.com.au> wrote:

>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 Thu Apr 20 2000 - 00:00:00 CDT