I am trying to compare two schema in Oracle 11gR2 using Tools->Database Diff, I got following error message.
I am using both connections as owner of objects, but not clear why this error ?
In fact, i compared lot of times with same connections, but today it is throwing this message.
Unable to compare objects.
Ensure that you have the required permissions.
You must own the objects or have select_catalog_role.
The exception message is clear.
The user doing the compare must either own ALL objects or you need to have the select-catalog_role.
So did you check the data dictionary to see if you have the select_catalog_role privilege?
If it worked before on the objects you had before then either there are NEW objects that you don't own or you don't have the role privilege.
created new tables in both schema and able to compare now.