Sorry to ask again - but I just checked and figured out that I requested this feature (compare objects in different schema in production environment with what we have in dev/QC) for the first time back in December, 2004. And I believe I was not alone with this request.
Though there was some improvement in this area with latest releases, we can still not do what we need. Is there any REAL problem in fixing it so it takes more than 5 years? Sorry again - but it doesn't look like our requests are counted...

Any chance to get any response?

We're looking into a solution.

Any chance to have an estimate? Wait 5 more years?

Can we expect this issue to be fixed soon?

Our organization would also greatly benefit from a solution to this compare object limitation. If it helps at all to raise the urgency of this case - we have an active 100 user support contract.

Would it be possible to get an update with respect to when we might be able to see a fix? ie. Will it make it into an 8.0 patch level?

We are working on a fix. At the moment you need to have access to the dba views for both the source and target connection.

Hi Marco,

Thanks for your help on this.

I tried compare from a source account with select_catalog_role to a target account with select_catalog_role so both accounts had access to the dba_views and they owned no objects. The compare window did not display any objects when I selected an object owning schema. The objects for the schema are, however, displayed in the object browser when "all users" or the schema is specified. It looks like the compare is not using the dba views even when "Use DBA view if available" option is checked.

[quote=djkucera]Our organization would also greatly benefit from a solution to this compare object limitation. If it helps at all to raise the urgency of this case - we have an active 100 user support contract.

Would it be possible to get an update with respect to when we might be able to see a fix? ie. Will it make it into an 8.0 patch level?
[/quote]
We are even bigger - unlimited user licence. And EVERY user in our organization is dreaming about this option...

I just wanted to check on this, please update.
Thanks