Printable View
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
Just to be sure - which version of Oracle?
it' 9.2
Quote:
Originally posted by DaPi
Just to be sure - which version of Oracle?
It's release 2. could u elobrate on this problem...i just dont get it.
If your system tablespace is localy managed you can't create any dictionnary managed tablespace.
I don't see any advantages in dictionnary manged tablesapces so why do you need it? Is there any reason why you can't use a localy managed tablespace?
As far as I know, the only way around is to recreate your database with a dictionnary managed system tablespace.
HTH
Mike
The reason is what the error message told. You can create a dictionary managed tablespace if the system tablespace is locally managed.
I think it should be "you cannot create dictionary managed tablespace if the system tablespace is locally managed."Quote:
Originally posted by Calvin_Qiu
The reason is what the error message told. You can create a dictionary managed tablespace if the system tablespace is locally managed.
HTH
As said by Mike u cannot create a dictionary managed tablespace once u defined your database to use Localy managed method.
Why would you like to create first of all a DMT in a 9.2 database?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
Are you longing for the past or what :-)