Error, "ORA-00955: name is already used by an existing object" because indexes are not being drop (4226528)

Indexes are not being dropped in the Schema Compare sync script when altering a primary key or unique key constraint.

The Schema Compare sync script drops the constraint and but does not drop the index. Thus when running the Toad generated Sync Script to Alter the table an ORA-00955: name is already used by an existing object error occurs.

Drop Index statement not part of the Schema Compare script.

WORKAROUND:

1. Send the sync script to the Toad Editor.
2. Adjust the script by adding DROP INDEX at the end of the first ALTER statement.

For example:

(ORIGINAL SYNC SCRIPT)
ALTER TABLE <table_name> DROP CONSTRAINT <constraint_name>;

(MODIFIED SYNC SCRIPT)
ALTER TABLE <table_name> DROP CONSTRAINT <constraint_name> DROP INDEX;

3. Execute the script.


STATUS:

Waiting for fix to be released in a future version of Toad for Oracle.