Thursday, August 16, 2012


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
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.
Then I was able to drop the USERS1 tablespace successfully:
SQL> drop tablespace users1;
Tablespace dropped.

No comments:

Post a Comment