ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE

I got ” ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE ” error in Oracle database.

 

ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE

Details of error are as follows.

SQL> ALTER TABLE MSDBA.TEST_TABLE MOVE SUBPARTITION SYS_SUBP3774272 TABLESPACE TBS_ODI UPDATE INDEXES parallel 96;
ALTER TABLE MSDBA.TEST_TABLE MOVE SUBPARTITION SYS_SUBP3774272 TABLESPACE TBS_ODI UPDATE INDEXES parallel 96
*
ERROR at line 1:
ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE

SQL>

ORA-14137: Table in partially dropped state, submit DROP TABLE PURGE
*Cause: An attempt was made to access a partitioned table in a partially
dropped state.
*Action: Submit DROP TABLE table_name PURGE to drop the table.

Additionally, table is in unusable status, as can be seen by executing the following statement:

 

 

This ORA-14137 error is related with the  attempt was made to access a partitioned table in a partially dropped state.

Check the Table  if it is unusable status or usable using the following script.

select * from dba_tables where owner = 'OWNER' and table_name = 'TABLE_NAME';

 

 

To solve this error, Submit DROP TABLE table_name PURGE to drop the table as follows.

SQL> drop table owner.table_name purge;

 

 

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

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

See more