ORA-00942 - Reading Dependency Information

[foomaniac]

Hi Guys,

We're attempting to evaluate the latest version of Scheme Compare, version 3, but we just can't get anywhere with it.

No matter we try, each time it tries to run the first stage 'Reading Dependency Information' if fails with the exception ORA-00942: table or view does not exist.

We have a few different schemas, but regardless of what we try it just won't go any further. The database we're comparing against is a recent backup from a week ago, so there shouldn't be much difference at all.

Is there anything obvious you think might be going on here? We've tried Data Compare and that appears to be quite happy on the same settings.

I can post the log file up if it's handy?

Cheers

[neil.anderson]

Hi Foomaniac,

Thanks for getting in touch. To read dependencies the user you are logged in as required permissions to read all_dependencies, all_constraints, all_objects, all_indexes, all_tab_cols, all_synonyms, all_indextype_operators, all_refs and all_nested_tables (or their dba equivalents depending on the user).

In your environment has your user, or PUBLIC, had the privilege revoked on any of those views?

Thanks,
Neil