Oracle Error Message
ORA-10656: Table is in unusable state due to incomplete operation
Reason for the Error
ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed/incomplete operation.
Solution
If the previous operation was
– DROP COLUMN, resubmit DROP COLUMN CONTINUE
– DROP TABLE, resubmit DROP TABLE
PURGE