"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
