Oracle Error ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

Oracle Error Message

ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE

Reason for the Error

An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).

Solution

Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.