Thursday, August 16, 2012

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>

No comments: