What I really don't understand - why is it so hard? It really looks like the problem is only in not using dba views while performing this operation. Are we missing something really complex? There are dozens of people in our company who are crying for this feature (and it looks like not in our company only). What is the real problem behind this request???

Hi Marco,

Have have looked at debug.txt file for compare user objects and the select that generates the compare list uses sys.all_objects and not a dba view. I hve emailed you the debug.txt file. I can not say what is being uses on the target since I need a list of objects first to run the compare. I do know that if I log into an object owning schema and the target user only has select_catalog_role the target object is not found.

Is there any chance at some point this problem is resolved?

any update on this issue.
I'm also waiting for a solution

Would be relay helpfull!!

Just curious - hom many posts from different users can move this problem from freezing point?

So far the answers have been "We're looking into a solution.", "We are working on a fix." and "I will post here when there is an update." What more do you want?

I want to see some progress. Do you really think it's OK to have such answers for the last 6 (!!!) years? This feature (compare objects in prod environment under different schema) was originally requested in 2004. Now - in 2010 - we still cannot do it.

Any chance to hear anything new on this problem?

Any chance to hear anything new on this problem?

Hi!

So far, in the rare situations I needed to perform this task, I would generate source files and "Compare Source" instead of "Compare Objects". But I've been assigned to a new customer and this activity has become more and more frequent. So I'd like to see this in 9, or in a patch after the major release.

Regards,
Gustavo