Dictionary Managed Tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Dictionary Managed Tablespace

  1. #1
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if system is LMT Then you cannot create DMT

  3. #3
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24
    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
    :)

  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    dba_tablespaces

  5. #5
    Join Date
    Nov 2002
    Location
    Argentina
    Posts
    24

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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_FROM_LOCAL('SYSTEM')

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

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    After you've gone through the pain of getting to LMT, why in the world would you want to go back?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width