Re: SNAPSHOT ERROR

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/SNAPSHOT-ERROR-tp1511p1516.html

Snapshot = MV

So, the answer to your question is Snapshot = MV :)

Snapshot log should be created on the instance locally.

Suppose, you have a table on DB A.
And suppose, you want to create an MV on DB B to retrieve the records from the table that resides on DB A.
Then you will create MV LOG on the table which resides on DB A.


MV LOGs are for tracking the changes for the MV refreshes.

Read oracle documentation for further info.