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

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 8 Mar 2001 17:47:05 +1100
Message-ID: <3aa72abe@news.iprimus.com.au>

I'm stuffed if I can see a single reference on that site to how to make SYSTEM a locally managed tablespace. All the scripts I saw have the create database command using autoextend and next clauses, which does not a locally managed tablespace make, and the wealth of information there about locally managed tablespaces appear to be entirely for NON-system tablespace.

Could you be more specific where they explain how to make SYSTEM locally managed?

Regards
HJR "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 - 00:47:05 CST