The error message is self-explanatory.
Which accounts are you using to do the compare in relation to the schemas being DIFF'd?
the same account (eot) in source database and in destination database
the source sid is eot_m
the detination sid is eot_r
It appears your EOT user doesn't have a high enough priv level to run the DIFF. First thing to check, does clicking on the SQL page for objects in both schemas successfully produce the DDL for those objects?
Yes i can produce DDL on source and destination databases
dbms_metadata.get_xml(?, ?, ?); end;
Can you successfully run that for one of the objects to be compared?
Example parameters to pass in
We also do a quick check to see if DBA_OBJECTS views is accessible...
You can see all of the db queries being sent when doing a DIFF (or anything else) when running SQL Developer v4.1, in the Log > Statements panel.
Its OK on both databases, the temporary TBS was corrupted, after reconfiguration i can compare objects.