Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help to resolve the error! ORA-12986: columns in partially dropped state.

446002Jun 20 2005 — edited Jun 24 2005
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2005
Added on Jun 20 2005
5 comments
3,325 views