problem: syncing table when name is same as synonym

Early Access Program for Schema Compare for Oracle

problem: syncing table when name is same as synonym

Postby mafujosh » Mon Mar 22, 2010 5:15 pm


(in version

Maybe you have this already handled in a newer release, but in case you don't:

When I am syncing a missing table into my database, it errors with "ORA-00955: name is already used by an existing object", because a synonym of that same name already exists. Deleting the synonym manually fixes this error.

The expected behavior, I think, would be to include the synonyms in the comparison window and have it show that one 1 side it is a table, and the other a synonym, and syncing would delete one before copying from the other.
Posts: 7
Joined: Thu Mar 11, 2010 3:42 pm

Postby alice.easey » Wed Mar 24, 2010 12:02 pm

Hi Mafujosh,

Thanks for your post.

We're implementing support for synonyms very soon - this work is currently scheduled for v1.

I'll keep you posted with any news on this upcoming release.

Posts: 94
Joined: Wed Feb 27, 2008 11:56 am
Location: Red Gate

Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests