updatable materialized views: updates made on materialized view site, not being applied to Master s
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
0