Oracle Solution for Error ora-10656

Solution for Oracle Error ORA-10656

ORA-10656: Table is in unusable state due to incomplete operation

What triggered the Error:

ALTER TABLE SHRINK operation was tried on the table which is in unusable state because of previously failed/incomplete operation.

What should we do to fix it:

If the previous operation was *- DROP COLUMN, resubmit DROP COLUMN CONTINU. *- DROP TABLE, resubmit DROP TABLE PURG.

If this was not sufficient go over to: Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board

Copyright 2020. All Rights Reserved