Table in partially dropped state, submit DROP TABLE PURGE

Solution ID:ORA-14137

Type: Oracle

Cause

An attempt was made to access a partitioned table in a partially dropped state.

Actions

Do not use DESC in reverse indexes. The rule-based optimizer can scan indexes backwards, which allows a normal reverse index to simulate a reverse index with columns marked DESC.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3229900


Browse all solutions to database errors from Oracle, MS SQL, or MySQL