How to fix the Oracle error ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE?

In this post, you’ll learn more about the Oracle ErrorORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE ?

You can fix this error in Oracle by following the below steps

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