cannot create dictionary managed tablespace
I'm trying to create a dictionary managed tablespace
" create tablespace data01
datafile "c:\......." size 2m
extent management dictionary"
I get ora-12913 error
error in the documentation says
"ORA-12913 Cannot create dictionary managed tablespace
Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.
Action: Create a locally managed tablespace."
Could someone explain this and tell me what to do
Re: cannot create dictionary managed tablespace
Quote:
Originally posted by sarahanand
I'm trying to create a dictionary managed tablespace
" create tablespace data01
datafile "c:\......." size 2m
extent management dictionary"
I get ora-12913 error
error in the documentation says
"ORA-12913 Cannot create dictionary managed tablespace
Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.
Action: Create a locally managed tablespace."
Could someone explain this and tell me what to do
Why would you like to create first of all a DMT in a 9.2 database?
Are you longing for the past or what :-)