Oracle DBA, How To, Error, Cause and Action

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

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

Cause:

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


Action:

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

No comments:

Post a Comment

Thanks for your comment.