Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Locally Managed vs Dictionary managed tablespaces
"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 UkReceived on Fri Nov 02 2001 - 03:14:58 CST