attempt to create PERMANENT object...

[Mustak]

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

[pipo]

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;

[jjongman]

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