Re: Locally Managed vs Dictionary managed tablespaces

From: Howard J. Rogers <howardjr_at_www.com>
Date: Fri, 2 Nov 2001 21:37:18 +1100
Message-ID: <3be2773b$0$1778$afc38c87@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.

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3be2645c$0$236$ed9e5944_at_reading.news.pipex.net...


> "Ricky Sanchez" <rsanchez_at_more.net> wrote in message

> news:3BE1CF33.2EE9C604_at_more.net...

> > I also noticed a comment suggesting system tablespace should always be

> > dictionary managed. Silly rationale and no logic is offered to support

> > it. LMT makes sense, so use it when you can. Soon enough, it will be the

> > only option anyway, so you might as well get used to it.

>

> How do you achieve this prior to 9i? Last time I looked you couldn't

specify


> local extent management when creating a database.

>

>

> --

> Niall Litchfield

> Oracle DBA

> Audit Commission Uk

>

>

>

Received on Fri Nov 02 2001 - 04:37:18 CST