Home » RDBMS Server » Server Administration » Ora-12913
Ora-12913 [message #168897] Mon, 24 April 2006 01:38 Go to next message
M. Pallas
Messages: 12
Registered: November 2004
Junior Member
Hi,
Thank you for extending the information on the 12913 error. But, does that mean that we no longer can create dictionary managed tspaces and take advantage of the storage clause???

12913, 00000, "Cannot create dictionary managed tablespace"
// *Cause: Attemp to create dictionary managed tablespace in database
// which has system tablespace as locally managed
// *Action: Create a locally managed tablespace.
Re: Ora-12913 [message #168899 is a reply to message #168897] Mon, 24 April 2006 01:44 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
LMTs are better than the DMTs.

http://www.orafaq.com/node/3

Salih KM
Re: Ora-12913 [message #168956 is a reply to message #168897] Mon, 24 April 2006 06:24 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
M Pallas,
Yes, onbce your system tablespace has been migrated to an LMT (Or was created as an LMT) you can no longer create DMTs. This is not a bad thing, as Salih says, LMTs are superior to DMTs

Jim
Re: Ora-12913 [message #168980 is a reply to message #168956] Mon, 24 April 2006 08:20 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
M.PALLAS wrote:
>> and take advantage of the storage clause?
What might they be?
As others said, DMT is just a pain.
http://www.orafaq.com/forum/m/165320/42800/?srch=DMT#msg_165320
Previous Topic: How to write DBMS_STATS package?
Next Topic: sqlnet.ora
Goto Forum:
  


Current Time: Fri Sep 20 14:31:41 CDT 2024