Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Locally Managed vs Dictionary managed tablespaces

Re: Locally Managed vs Dictionary managed tablespaces

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 2 Nov 2001 12:25:11 -0000
Message-ID: <3be290f1$0$237$ed9e5944@reading.news.pipex.net>


"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3be2773b$0$1778$afc38c87_at_news.optusnet.com.au...
> Not only can you not create SYSTEM as anything other than dictionary
managed
> tablespace in 8i, you can't do it in 9i either.
>
> It was wrongly documented in 8i that you could; it is correctly documented
> in 9i that you can't.
>
> Therefore, quite where that last comment was coming from on Ricky's part,
I
> haven't a clue.

The database configuration assistant in 9i on NT however does let you specify system as an LMT. Of course it then ignores this and creates it as dictionary managed anyway.

--
Niall Litchfield
Oracle DBA
Audit Commission Uk
Received on Fri Nov 02 2001 - 06:25:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US