Toad World® Forums

Single object compare


#1

I compared 2 materialized views using the ‘compare with another object’ rt-click in SB, and Toad incorrectly flagged the synonyms as different. The UAT version showed synonyms A then B, while Prod showed B then A. Would you be able to add an order by when checking synonyms?

Thanks


#2

I do have an order by for the synonyms in beta. They are ordered by synonym name.

It might not have been there for the 12.0 GA – are you talking about beta or GA? Just to make sure we’re talking about the same thing, can I see a screen
shot?

From: michael.c.nisse_546 [mailto:bounce-michaelcnisse_546@toadworld.com]

Sent: Wednesday, July 24, 2013 5:20 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Single object compare

Single object compare

Thread created by michael.c.nisse_546

I compared 2 materialized views using the ‘compare with another object’ rt-click in SB, and Toad incorrectly flagged the synonyms as different. The UAT version showed synonyms A then B, while
Prod showed B then A. Would you be able to add an order by when checking synonyms?

Thanks

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#3

This is in the current Beta. I should have said that the synonym names are the same, but the owners are different: schema1.A and schema2.B.


#4

oops, sorry, not enough coffee this morning. That should have read schema1.A and schema2.A.


#5

Oh, I am just ordering by name. OK, I’ll add owner in there too.

From: michael.c.nisse_546 [mailto:bounce-michaelcnisse_546@toadworld.com]

Sent: Thursday, July 25, 2013 8:23 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Single object compare

RE: Single object
compare

Reply by michael.c.nisse_546

oops, sorry, not enough coffee this morning. That should have read schema1.A and schema2.A.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.