Oracle Solution for Error ora-12986
ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
What triggered the Error:
An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).What should we do to fix it:
Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
