ORA-12919

I had this problem while preparing another example on Oracle 11.2:

 

SQL> drop tablespace users1;

drop tablespace users1

*

ERROR at line 1:

ORA-12919: Can not drop the default permanent tablespace

 

SQL>

 

i.e. I was unable to drop the USERS1 tablespace as it was the default for new objects. To get round this I made USERS2 the default tablespace instead:

 

SQL> alter database default tablespace users2;

 

Database altered.

 

SQL>

 

Then I was able to drop the USERS1 tablespace successfully:

 

SQL> drop tablespace users1;

 

Tablespace dropped.

 

SQL>

Reply to: Reply to Andrew Reid

Send