Red Gate forums :: View topic - problem: syncing table when name is same as synonym
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle Beta
Schema Compare for Oracle Beta forum

problem: syncing table when name is same as synonym

Search in Schema Compare for Oracle Beta forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
mafujosh



Joined: 11 Mar 2010
Posts: 7

PostPosted: Mon Mar 22, 2010 6:15 pm    Post subject: problem: syncing table when name is same as synonym Reply with quote

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.
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Wed Mar 24, 2010 1:02 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group