Dictionary Managed Tablespace

[mquesada]

Im trying to create a dictionary managed tablespace on my Oracle 9.2.0.1 TEST database, where i have all others tablespaces Locally managed created.
I dont know why, but i cant create a Dictionary-Managed tablespace, could anybody bring me some help please ?

this is the SQL used
CREATE TABLESPACE DATA2
DATAFILE 'D:\BASETEST\TEST\ORADATA\DATA21.DBF' SIZE 10M
EXTENT MANAGEMENT DICTIONARY
DEFAULT STORAGE (
INITIAL 50K
NEXT 50K
MINEXTENTS 2
MAXEXTENTS 50
PCTINCREASE 0);

Thank you all ..

[pando]

if system is LMT Then you cannot create DMT

[mquesada]

where can i see if my system was crated LMT or DMT ?
If is LMT, is it possible to change it to DMT?, How?

[aarroyob]

dba_tablespaces

[mquesada]

Sorry but:
If my system is LMT, is it possible to change it to DMT to create a Dictonary managed tablespace?, if yes, How can i change it?

[pando]

DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM')

I am not sure if it's supported, never done it

[marist89]

After you've gone through the pain of getting to LMT, why in the world would you want to go back?