Home » RDBMS Server » Server Administration » How to Creating dictionary managed tablespace in 10g (Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 in RHEL4 AS)
How to Creating dictionary managed tablespace in 10g [message #415305] Mon, 27 July 2009 03:25 Go to next message
anwar786
Messages: 25
Registered: May 2009
Location: bangalore
Junior Member
Guys how to create dictionary managed tablespace in 10g. i know that we cannot create dictionary tablespace without changing SYSTEM to dictionary but in online documentation it says we can create dictioanry tablespaces in 10g if we explicitly provide Dictionary in extent management.
But is there any way that we can change ?
Re: How to Creating dictionary managed tablespace in 10g [message #415317 is a reply to message #415305] Mon, 27 July 2009 04:35 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
But is there any way that we can change ?

No. Database must be created with a DMT SYSTEM tablespace.
But why do you want to use a DMT?

Regards
Michel
Previous Topic: ORA-01591: lock held by in-doubt distributed trans - I hope to help more people
Next Topic: Memory leak after upgrading 9.2.0.4 to 10.2.0.4
Goto Forum:
  


Current Time: Fri Nov 29 13:27:42 CST 2024