Results 1 to 7 of 7
  1. #1
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Unanswered: Dictionary managed tablepsaces on Oracle 9.2

    Hello,

    We have an application that needs some adjustment before it can use LMT efficiently.
    I have two questions:

    1
    ===
    Can I configure Oracle 9.2 to work with DMT ?
    I tried creating one as described in the 9.2 docs and get the following response:

    SQL> CREATE TABLESPACE test
    2 DATAFILE 'D:\oracle\oradata\studio92\test.dbf' SIZE 10M
    3 EXTENT MANAGEMENT DICTIONARY
    4 DEFAULT STORAGE (
    5 INITIAL 100K
    6 NEXT 5120K
    7 MINEXTENTS 2
    8 MAXEXTENTS unlimited
    9 PCTINCREASE 0);
    CREATE TABLESPACE test
    *
    ERROR at line 1:
    ORA-12913: Cannot create dictionary managed tablespace

    When I check what is ORA-12913, I see that if I have LMT system I can not use DMT , is that true ?



    2
    ===
    If I do change my system tbs to work with DMT, will I be able to use DMT.



    Guys, try answering the direct questions instead of telling me that LMT is better, as I wrote above, there is a functional problem in my application that currently can not use it.

    TIA

  2. #2
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279

  3. #3
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73

    Read it before posting, how should that help me ?

  4. #4
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Why don't you take two seconds and look at it? What exactly do you think
    After the SYSTEM tablespace is migrated to locally managed, any dictionary-managed tablespaces in the database cannot be made READ WRITE. If you want to be able to use the dictionary-managed tablespaces in READ-WRITE mode, Oracle recommends that you first migrate these tablespaces to locally managed before migrating the SYSTEM tablespace.
    means?

  5. #5
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73
    Originally posted by marist89
    Why don't you take two seconds and look at it? What exactly do you think

    means?
    I did look at it, but either I did not phrase my question good enough or you have not understood it !
    The motivation is to configure 9i (9.20 with DMT) so what relates your link 'migrating the system into LMT' to the issue ?

    Tal.

  6. #6
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    OK, I understand now, I have to hold your hand. The "Note" clearly states that you can't have READ-WRITE DMT tablespaces with a LMT SYSTEM tablespace. So, yes, an ORA-12913 error was correctly thrown when you tried to create a DMT in a database that has an LMT SYSTEM tablespace.

  7. #7
    Join Date
    Aug 2002
    Location
    IL
    Posts
    73
    Originally posted by marist89
    OK, I understand now, I have to hold your hand. The "Note" clearly states that you can't have READ-WRITE DMT tablespaces with a LMT SYSTEM tablespace. So, yes, an ORA-12913 error was correctly thrown when you tried to create a DMT in a database that has an LMT SYSTEM tablespace.

    Look at the original question (no. 2):
    If I do change my system tbs to work with DMT, will I be able to use DMT?

    1. You could just answer yes or no.
    2. Thanks for all the additonal info.
    3. Look around, don't see any friends? read all your last post and see y !

Posting Permissions

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