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

There was an item in th 8.1.5 manuals
stating that you could make SYSTEM
and LMT but only if all the rollback segments were in tablespaces that were also LMT.

However, I also found a note elsewhere
when looking into this possibility that
pointed out that this was an error in the manuals, and SYSTEM could not be
created as an LMT. This may have
changed (along with other features of
LMTs) with 8.1.6 and 8.1.7

On the question of 'it's so simple' - the thing that puzzles me is why the default database generated for 8.1.5 (and possibly later) doesn't use a TEMPORARY tablespace for the temporary tablespace ? Sometimes inertia is the strongest reason for not changing something.

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

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Howard J. Rogers wrote in message <3aa72abe_at_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

>>

>

>