Database DataWarehousing (MOSC)

MOSC Banner

Materialized View fast refresh fails with ora 0942 table does not exist

edited Jan 15, 2010 3:16AM in Database DataWarehousing (MOSC) 9 commentsAnswered
  We have created materialized view which need to be refreshed every 15 minutes .

 

The master table  is on remote db ,

I have given permission to select ,alter ,update the master table/log table(mview$_tablename) to the owner of the db link on master site .

 

the complete refresh is successful but  fast and force fails with ORA 0942 : TABLE DOES not exist .

 

please help

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center