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

I know there's a package that's supposed to be able to convert dictionary tablespace to locally managed (all sounds faintly dodgy to me, and it blew up the only time I tried it) in 8.1.6 and above. I'd be interested to see if would work against SYSTEM (but I'll lay odds that it wouldn't).

The point about inertia is well taken (though I reckon it's just Oracle's wry way of sorting out the DBAs from the button-pushers ;-) )

Regards
HJR "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:984043178.17395.1.nnrp-02.9e984b29_at_news.demon.co.uk...
>
> 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
> >>
> >
> >
>
>
Received on Thu Mar 08 2001 - 03:37:49 CST