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 Tablespace for System Tabespace ?

Re: Locally Managed Tablespace for System Tabespace ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 16 Jul 2002 08:58:07 +0100
Message-ID: <3d33d210$0$236$ed9e5944@reading.news.pipex.net>


"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:UMwY8.35407$Hj3.106468_at_newsfeeds.bigpond.com...
> Thanks Niall,
>
> I guess the word *default* needs some interpretation.
>
> The ODCA by *default* through it's templates has the EXTENT MANAGEMENT
LOCAL
> clause specified. Therefore it creates a LMT for System by default.
>
> A manual creation of a database through CREATE DATABASE by *default*
creates
> a DMT for System. You must specify EXTENT MANAGEMENT LOCAL clause in order
> to create a LMT for System.

You are of course absolutely right (and that's getting to be a habit stop it at once <g>). I had in mind the default behaviour of the assistant (assuming thats what many/most users would use) not the various defaults of the relevant sql statements.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
Received on Tue Jul 16 2002 - 02:58:07 CDT

Original text of this message

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