Printable View
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 ..
if system is LMT Then you cannot create DMT
where can i see if my system was crated LMT or DMT ?
If is LMT, is it possible to change it to DMT?, How?
dba_tablespaces
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?
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM')
I am not sure if it's supported, never done it
After you've gone through the pain of getting to LMT, why in the world would you want to go back?