Site icon IT Tutorial

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

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>

 

 

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

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

Exit mobile version