Re: Is it possible to create a System tablespace with Local managed extent?

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Thu, 8 Mar 2001 14:50:55 -0000
Message-ID: <984063065.26505.0.nnrp-02.c30bdde2@news.demon.co.uk>

On this note (sort of), I'm trying some experiments just now on a test machine with locally managed tablespaces.

I've got them all - except system, obv. - set to either autoallocate or uniform extent as appropriate, but when I tried to create rollback segments, it said I couldn't create them in my rbs tablespace... I take it - given sizing of rbs and initial/next/optimum clauses in rbs segment creation - that rbs can't be in locally managed tablespace?

In the O8 chapter that explains the concepts of lmt's, this isn't mentioned - though my 'explanation' seems logical enough.

(ps. I haven't posted this to all the ng's in case you're wondering..)

"Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3AA72736.B43C354A_at_exesolutions.com...
> > Is it possible to create a System tablespace with Local managed extent?
> > Is it better off to have the system tablespace to be dictionary managed?
>
> It is definitely possible. Go to http://otn.oracle.com and enter the
search
> criterion "LOCALLY MANAGED". You will find lots of good reference material
> on the subject.
>
> Daniel A. Morgan
>
Received on Thu Mar 08 2001 - 08:50:55 CST