ORA-12919: Can not drop the default permanent tablespace

Mehmet Salih Deveci

5 years ago

Hi,

Sometimes you can get “ORA-12919: Can not drop the default permanent tablespace ” error.

Details of error are as follows.

ORA-12919: Can not drop the default permanent tablespace

Cause: An attemp was made to drop the default permanent tablespace

Action: Make a different tablespace as the default permanent tablespace and reissue the drop


SQL> drop tablespace datatbs;
drop tablespace datatbs
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace

SQL>

You cannot drop the default tablespace of database because of new objects.

You should firsly change the default tablespace of database to new tablespace as follows.


SQL> alter database default tablespace data;

Database altered.

SQL>

Then you can drop it as follows.

SQL> drop tablespace datatbs;

Tablespace dropped.

SQL>