Re: Locally Managed Tablespace for System Tabespace ?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sat, 13 Jul 2002 17:08:57 +1000
Message-ID: <wfQX8.33980$Hj3.102871@newsfeeds.bigpond.com>

Hi Ora,

Yes you can have a LMT for SYSTEM TS in 9iR2.

Use the new 'EXTENT MANAGEMENT LOCAL clause in the CREATE DATABASE statement (default behaviour is still to use a DMT)

Note that this can't later be changed nor can you create any other DMT.

Regards

Richard
"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:qwPX8.489360$352.81834_at_sccrnsc02...
> Not in 8i or 9.1, maybe 9.2. Have to read the documentation.
> Jim
> "Ora" <ora_geek_at_yahoo.com> wrote in message
> news:fa5d6718.0207122046.86b4197_at_posting.google.com...
> > Is it possible to have Locally Managed Tablespace (LMT) for SYSTEM
> Tablespace also ?
> >
> > If so , how can we convert an existing Dictionary Managed SYSTEM
> Tablespace to LMT ?
> >
> > OrA
>
>
Received on Sat Jul 13 2002 - 02:08:57 CDT