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

Thread: Error

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Error

    When i tried to create the tablespace as,

    SQL> create tablespace tbs01
    2 datafile 'c:\oracle\oradata\newdb\new.dbf' size 250k
    3 extent management dictionary;
    create tablespace tbs01
    *
    ERROR at line 1:
    ORA-12913: Cannot create dictionary managed tablespace


    I got this error,

    1) Why it's giving this error?

    2) What is the solution for this error?


    Anyone please answer for this as soon as possible.

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    1 - Because your sytem tablespace is locally managed.
    2 - You need to recreate your database with system tablespace dictionary-managed
    or
    create your new tablespace locally managed.
    Think.
    Act..
    Be proud...

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and then find a dba who can answer your questions or guide you through stuff

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