-
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
-
Just to be sure - which version of Oracle?
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
-
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.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
-
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.
I think it should be "you cannot create dictionary managed tablespace if the system tablespace is locally managed."
HTH
Amar
"There is a difference between knowing the path and walking the path."
-
As said by Mike u cannot create a dictionary managed tablespace once u defined your database to use Localy managed method.
-
Re: cannot create dictionary managed tablespace
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 :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|