Help to resolve the error! ORA-12986: columns in partially dropped state.
446002Jun 20 2005 — edited Jun 24 2005Hi All!
I've encountered a problem and I am completely stuck with it.
When I attempt to drop a table I receive the following message:
VBO-4562 : Table cannot be dropped.
ORA-00604: error occurred at recursive SQL level 1
ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
When I issue the ALTER TABLE DROP COLUMNS CONTINUE command I receive the following message:
ORA-00955: name is already used by an existing object
There is no indication of what name is causing the problem.
As a workaround I tried to export/import into a second database and delete the table (successful) and then delete the user/schema in the original database and export/import from the second database. When I attempt to delete the user in the original database I get the same "column partially dropped" message.
Any ideas?
Thanks,
Alexandr