Database Administration (MOSC)

MOSC Banner

updatable materialized views: updates made on materialized view site, not being applied to Master s

edited Mar 9, 2009 9:32AM in Database Administration (MOSC) 2 commentsAnswered
I recently cloned two databases to create test databases.  I upgraded the cloned master site  from Oracle 9.2.0.8.0 Enterprise Edition to Oracle 10.2.0.8.0 Standard Edition using a full database export.  I also upgraded the cloned materialized view db from 9.2.0.8.0 EE to 10.2.0.8.0  EE.   I had to rebuild my replication group on the master db.  I thought everything was going well but, changes in at least one materialized view on the MV site do not get passed to the Master Site and the MV gets set back to it's original status, like it is being forced to do a complete refresh instead of pushing changes

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