ORA-14404 error during the drop tablespace operation

 

If the tablespace that is dropped is empty, but is the default storage space for any partition, the drop operation will cause the ORA-14404 error and will not be dropped.

An error will occur during the process as follows.

In this case, it is necessary to detect the partition and change the tablespace information.

You can use the following query to detect the partition that uses Tablespace.

Write your tablespace name instead of TABLESPACE_NAME in the above query.

After detecting Partition, you can change the tablespace that partittion uses with the following command:

The corresponding tablespace can then be dropped succesfuly.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *