cannot create dictionary managed tablespace

[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

[DaPi]

Just to be sure - which version of Oracle?

[sarahanand]

it' 9.2

[sarahanand]

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.

[mike9]

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

[Calvin_Qiu]

The reason is what the error message told. You can create a dictionary managed tablespace if the system tablespace is locally managed.

[adewri]

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

[akhadar]

As said by Mike u cannot create a dictionary managed tablespace once u defined your database to use Localy managed method.

[julian]

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 :-)