problem: syncing table when name is same as synonym

Early Access Program for Schema Compare for Oracle

Moderators: David Atkinson, eddie davis, richardjm, alice.easey, Tom Harris

problem: syncing table when name is same as synonym

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

fyi

(in version 1.0.0.691)

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.
mafujosh
 
Posts: 7
Joined: Thu Mar 11, 2010 4:42 pm

Postby alice.easey » Wed Mar 24, 2010 1: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.

Alice.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate


Return to Schema Compare for Oracle Beta

Who is online

Users browsing this forum: No registered users and 0 guests