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

Thread: Dictionary Managed Tablespace

  1. 11-15-2002, 02:47 PM #1
    mquesada
    mquesada is offline Junior Member
    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
    :)
    Reply With Quote Reply With Quote
  2. 11-15-2002, 02:49 PM #2
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if system is LMT Then you cannot create DMT
    Reply With Quote Reply With Quote
  3. 11-15-2002, 03:11 PM #3
    mquesada
    mquesada is offline Junior Member
    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
    :)
    Reply With Quote Reply With Quote
  4. 11-15-2002, 03:13 PM #4
    aarroyob
    aarroyob is offline Senior Advisor
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    dba_tablespaces
    Reply With Quote Reply With Quote
  5. 11-15-2002, 03:47 PM #5
    mquesada
    mquesada is offline Junior Member
    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
    :)
    Reply With Quote Reply With Quote
  6. 11-15-2002, 03:56 PM #6
    pando
    pando is offline Pando & Company
    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
    Reply With Quote Reply With Quote
  7. 11-15-2002, 04:18 PM #7
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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