disallow MV use of MV logs?
We are having a MV user1.mv1 on user1.table1 having MV logs for enabling fast refresh on commit.
A second MV user2.mv1 exists on user1.table1 in the same DB, just in another user.
Now dba_snapshot_logs shows that user2.mv1 is using the MV logs thus the refresh (running time ~ 1.5 hours) fails with ora-12034 as user1.mv1 was obviously refreshed in the meantime by a commit.
Is there a way to disallow user2.mv1 to use the logs of user1.mv1? I tried dbms_snapshot.purge_snapshot_from_log but that didn't work. unregister_mview and unregister_snapshot both brought ORA-12020 errors.
Now dba_snapshot_logs shows that user2.mv1 is using the MV logs thus the refresh (running time ~ 1.5 hours) fails with ora-12034 as user1.mv1 was obviously refreshed in the meantime by a commit.
Is there a way to disallow user2.mv1 to use the logs of user1.mv1? I tried dbms_snapshot.purge_snapshot_from_log but that didn't work. unregister_mview and unregister_snapshot both brought ORA-12020 errors.
0