I am getting the error ORA-00942 when I fill in the second database connection in the Database | Compare | Single Objects window. I am able to perform this task in Toad for Oracle 9.7.2 but is getting the error in Toad for Oracle 10.5.1.3.
RESOLUTION:
Toad runs a different queries to populate the database field from version 9.7.2 to 10.5.1.3. User will need additional privilege to perform this task.
Run the grant below for the user on the database:
grant select on dba_attribute_transformations to user;