RE: System tablespace Default creation -> DMT or LMT in ver 10.2 ?

Hi Vivek,  

DMT is deprecated and not advisable to use. It just exists in 9i/10g for backwards compatibility towards 8i and older releases. Use LMT when possible, as the overall performance is quite better and it is easier to set up. Regarding the 10g documentation, DMT is default but take care that if you want to specify AUTOALLOCATE or UNIFORM clauses, you are required to have also the EXTENT MANAGEMENT LOCAL clause.  

I hope that helps.  

Regards,

Tristan  

PS: Try to get access to the online Oracle documentation from your workspace; the information you seek is all there in plain and easy to understand English. Maybe you can convince your system administrator about this. ;)  

Tristan van Essen

Accenture Technology Solutions AG

Baslerstrasse 60

CH-8048 Zürich

Office: +41 44 405 3245

Mobile: +41 79 654 0592

Email: tristan.van.essen_at_accenture.com

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Montag, 7. August 2006 14:42
To: oracle-l_at_freelists.org
Subject: System tablespace Default creation -> DMT or LMT in ver 10.2 ?  

Folks  

• By Default on creation is the system tablespace - DMT or LMT in ver Oracle 10.2?
• Which is advisable & why?

If System tablespace if LMT, conversion of Other Tablespaces of the Database from LMT to DMT is NOT possible.  

Thanks indeed  

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

--
http://www.freelists.org/webpage/oracle-l