RE: LMT SYSTEM Tablespace?

From: Stephen Andert <StephenAndert_at_firsthealth.com>
Date: Wed, 17 Mar 2004 09:44:06 -0700
Message-ID: <s0581dff.061@SLCM02.firsthealth.com>

Thanks to all who replied. Ruth, Dennis, Tom & Hemant.

Excerpts from the replies are below.

Based on this, I think we are proceeding as we have been. That is to say, databases that are upgraded are keeping SYSTEM as DMT and new installs will get LMT for SYSTEM. For all other tablespaces, we are moving to LMT.

Thanks!
Stephen Andert

>>>>>>

I see no good reason why to change the SYSTEM tablespace to an LMT. I say
wait until Oracle says it is required and then do it. Probably in 10G.
It's working as it is, so I would leave it alone.

>>>>>>

I use LMT SYSTEM in 9.2.0.2 and 9.2.0.4 on Tru64 and Solaris without any issues

>>>>>>

Yes, in 9i LMT is the default for system tablespace and if that is LMT you cannot create a
DMT. Haven't tried it, just quoting.

>>>>>>

In earlier versions the system tablespace was not supposed to be locally
managed. In 9.2.0.x you can and probably should make it locally managed.
I just did this on my production databases.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 17 2004 - 10:41:36 CST

RE: LMT SYSTEM Tablespace? - SUMMARY