-
Dictionary Managed Tablespace
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 ..
Marcelo Quesada
:)
-
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?
Marcelo Quesada
:)
-
-
I still have a question
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?
Marcelo Quesada
:)
-
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?
Jeff Hunter
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
|