Red Gate forums :: View topic - ORA-00942 - Reading Dependency Information
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Schema Compare for Oracle
Schema Compare for Oracle forum

ORA-00942 - Reading Dependency Information

Search in Schema Compare for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
foomaniac



Joined: 06 Dec 2012
Posts: 1

PostPosted: Thu Dec 06, 2012 11:26 am    Post subject: ORA-00942 - Reading Dependency Information Reply with quote

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
Back to top
View user's profile Send private message
neil.anderson



Joined: 28 Sep 2010
Posts: 64

PostPosted: Sun Dec 09, 2012 11:42 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group