| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: LMT SYSTEM Tablespace? - SUMMARY
Only one correction, if you use DBCA to create the database, the SYSTEM tablespace is LMT by default.
In 9iR2 you must specify the EXTENT MANAGEMENT LOCAL clause in the CREATE DATABASE statement to create a LMT SYSTEM tablespace if manual DB creation (using scripts).
And another catch is, if you explicitly specify EXTENT MANAGEMENT DICTIONARY in the CREATE DATABASE, you will get an "invalid extent management" error.
Also, if you decide to create SYSTEM LMT, make sure you specify the "DEFAULT TEMPORARY TABLESPACE" in the CREATE DATABASE. And you no longer can create DICTIONARY managed tablespaces in the database.
B
-----Original Message-----
From: Stephen Andert [mailto:StephenAndert_at_firsthealth.com]
Sent: Wednesday, March 17, 2004 10:44 AM
To: oracle-l_at_freelists.org
Subject: RE: LMT SYSTEM Tablespace? - SUMMARY
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _____________________________________________________________________________________________________________ This electronic transmission and any attached files are intended solely for the person or entity to which they are addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Any review, retransmission, dissemination or other use, including taking any action concerning this information by anyone other than the named recipient, is strictly prohibited. If you are not the intended recipient or have received this communication in error, please immediately notify the sender and destroy this communication. ---------------------------------------------------------------- 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 - 11:01:05 CST
 |
 |