ORA-00942 - Reading Dependency Information

Compares and synchronizes the schemas of Oracle databases

ORA-00942 - Reading Dependency Information

Postby foomaniac » Thu Dec 06, 2012 10:26 am

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?

Posts: 1
Joined: Thu Dec 06, 2012 10:20 am

Postby neil.anderson » Sun Dec 09, 2012 10:42 am

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?

Posts: 64
Joined: Tue Sep 28, 2010 1:17 pm

Return to Schema Compare for Oracle

Who is online

Users browsing this forum: No registered users and 0 guests