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

Thread: Tablespace creation error

  1. #1
    Join Date
    Feb 2006
    Posts
    162

    Tablespace creation error

    I got the following error when i tried to create a tablespace as follows,

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


    Can anyone explain me,

    1) What is the reason for this error?
    2) What i've to do to avoid this error?


    Thanks,
    Malru

  2. #2
    Join Date
    Apr 2001
    Posts
    107
    double post
    Think.
    Act..
    Be proud...

  3. #3
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    You are trying to create dictionary managed tablespace on database with SYSTEM tablespace is locally managed.

    Please create temp tablespace with

    Create temporary tablespace temp1 tempfile 'filename' size 250m;

    Cheers
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

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