Re: Locally Managed Tablespace for System Tabespace ?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 13 Jul 2002 20:56:49 +0100
Message-ID: <3d308909_2@mk-nntp-1.news.uk.worldonline.com>

"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

Hi, OrA.

This is best understanding, rather than authoritative, so others, please correct me if I'm wrong...

Yes, but only with 9i r2.
You can't; it has to be specified at db creation time.

HTH,
Paul Received on Sat Jul 13 2002 - 14:56:49 CDT