ORA-12919: Can not drop the default permanent tablespace

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

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>

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/