cannot create dictionary managed tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: cannot create dictionary managed tablespace

Hybrid View

  1. #1
    Join Date
    Apr 2003
    Posts
    24

    cannot create dictionary managed tablespace

    I'm trying to create a dictionary managed tablespace

    " create tablespace data01
    datafile "c:\......." size 2m
    extent management dictionary"

    I get ora-12913 error
    error in the documentation says

    "ORA-12913 Cannot create dictionary managed tablespace

    Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

    Action: Create a locally managed tablespace."

    Could someone explain this and tell me what to do

  2. #2
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Just to be sure - which version of Oracle?
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  3. #3
    Join Date
    Apr 2003
    Posts
    24
    it' 9.2

  4. #4
    Join Date
    Apr 2003
    Posts
    24
    Originally posted by DaPi
    Just to be sure - which version of Oracle?

    It's release 2. could u elobrate on this problem...i just dont get it.

  5. #5
    Join Date
    Mar 2002
    Posts
    534
    If your system tablespace is localy managed you can't create any dictionnary managed tablespace.

    I don't see any advantages in dictionnary manged tablesapces so why do you need it? Is there any reason why you can't use a localy managed tablespace?

    As far as I know, the only way around is to recreate your database with a dictionnary managed system tablespace.

    HTH
    Mike

  6. #6
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    The reason is what the error message told. You can create a dictionary managed tablespace if the system tablespace is locally managed.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  7. #7
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by Calvin_Qiu
    The reason is what the error message told. You can create a dictionary managed tablespace if the system tablespace is locally managed.
    I think it should be "you cannot create dictionary managed tablespace if the system tablespace is locally managed."

    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  8. #8
    Join Date
    May 2001
    Posts
    736
    As said by Mike u cannot create a dictionary managed tablespace once u defined your database to use Localy managed method.

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: cannot create dictionary managed tablespace

    Originally posted by sarahanand
    I'm trying to create a dictionary managed tablespace

    " create tablespace data01
    datafile "c:\......." size 2m
    extent management dictionary"

    I get ora-12913 error
    error in the documentation says

    "ORA-12913 Cannot create dictionary managed tablespace

    Cause: An attempt was made to create a dictionary managed tablespace in a database whose SYSTEM tablespace is locally managed.

    Action: Create a locally managed tablespace."

    Could someone explain this and tell me what to do
    Why would you like to create first of all a DMT in a 9.2 database?

    Are you longing for the past or what :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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