Database DataWarehousing (MOSC)

MOSC Banner

disallow MV use of MV logs?

edited May 20, 2011 4:09AM in Database DataWarehousing (MOSC) 6 commentsAnswered
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.

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