attempt to create PERMANENT object...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: attempt to create PERMANENT object...

  1. #1
    Join Date
    Jul 2001
    Location
    Bangalore
    Posts
    29

    Cool

    Hi,

    I created database through database configuration assistant.
    I am not able to create the tables in that db. When i try to create through wizard it shows following error message.

    ora-02195 attempt to create PERMANENT object in temporary tablespace.


    please help me to overcome this error message.

    thankx
    mustak

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    it's because the tablespace in which you try to create a table is in TEMPORARY mode (contents column in dba_tablespaces), which means that you cannot create an object in that tablespace.
    2 solutions :
    1) change the tablespace in which you create the object
    2) change your tablespace mode :
    alter tablespace ... permanent;

  3. #3
    Join Date
    Jul 2001
    Location
    Netherlands (Utrecht)
    Posts
    21
    It seems that your wizard try's to create your tables (or other objects) into a tablespace that has been assigned as a temporary tablespace...

    I don't know wich wizard you are using but are you able to tell your wizard in wich tablespace you want your tables...

    Do you know what the default tablespace is of the user that is creating the objects...??

    Grtx,
    Jeroen
    J.Jongman - DBA

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