Re: cleaning up rollback segments

I think the default install mechanism
'createdb1.sql' createdb2.sql etc. that
Oracle used to use created R0 before
creating other tablespaces, then created R01 to R04 before taking R0 offline.

It's a hangover from v6 days where you
couldn't even create a tablespace until
you had a 'non-system' rollback segment.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Doug Cowles wrote in message <38fe6d2f.350973_at_news.remarq.com>...


>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..

>