http://www.art2dec.com/documenta ... 01/README_rdbms.htm
Bug 3342089
Attempts to DROP TABLE result in an ORA-04063: table has errors when both of these conditions are true:
The table being dropped has columns that depend on an invalid type, such as a type that was altered or dropped forcibly without upgrading its dependents.
The RecycleBin feature is enabled for UNDROP TABLE support.
Workaround:
There are several workarounds for this problem:
Use DROP TABLE ... PURGE instead, if you are certain that you will not need to UNDROP the table at a later time.
Use ALTER TABLE ... UPGRADE INCLUDING DATA; DROP TABLE ..., if you will need to UNDROP the table at a later time.
Alternatively, you can use a temporary table, which allows you to delete the invalid table and retain the ability to UNDROP the valid subset of the original table. This is illustrated in the following script:
CREATE TABLE TMP AS SELECT * FROM ORIG;
DROP TABLE ORIG PURGE;
ALTER TABLE TMP RENAME TO ORIG;
DROP TABLE ORIG;