Re: SYSTEM tablespace always has to be dictionary managed?

Peter wrote:

> I have some conflicting information here.
> Does the SYSTEM tablespace always have to be dictionary managed?
> Version compatibility 9.0.0 or above?
> If the system tablespace is locally managed, then the other
> tablespaces in the database cannot be dictionary managed?
>
> Thanks

In the future please put some effort into solving your own problems before asking others to do it for you.

We are here to help ... true ... but prefer to help those that attempt to help themselves.

A one second investment at http://tahiti.oracle.com searching for: "SYSTEM TABLESPACE" AND "LOCALLY"
returned this:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/create.htm#1024555

Restrictions related to a locally managed system tablespace are discussed as well.

Which should be no problem as there is no excuse for using dictionary managed tablespaces if yo can avoid them.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)