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: Ricky Sanchez <rsanchez_at_more.net>
Date: Fri, 02 Nov 2001 15:04:46 GMT
Message-ID: <3BE2B64E.6A808477@more.net>


Of course, you cannot. Hence my suggestion was "...when you can."

Niall Litchfield wrote:
>
> "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 - 09:04:46 CST

Original text of this message

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