Skip to content

How to Resolve ORA-12906: cannot drop default temporary tablespace

  • by

ORA-12906

Tried to drop a temporary tablespace, but it failed with ORA-12906.

SQL> drop tablespace temp1 including contents and datafiles;
drop tablespace temp1 including contents and datafiles
*
ERROR at line 1:
ORA-12906: cannot drop default temporary tablespace

ORA-12906 means that the tablespace you want to drop is required to be the default temporary tablespace of the database.

To solve ORA-12906, you have to change the default temporary tablespace to another one.

Leave a Reply

Your email address will not be published.