materialize view logs rfresh [message #658076] |
Fri, 02 December 2016 09:37 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e1807e23242de2805a657f4ad9ae6654?s=64&d=mm&r=g) |
guddu_12
Messages: 227 Registered: April 2012 Location: UK
|
Senior Member |
|
|
Dear Sir,
I wanted to track changes onto a table so create MV logs and materialize view.
I don't understand how to find changed records once the MV is refreshd.
How can some one track the changed records as don't have any audit column in MV.
|
|
|
|
|
|
|
Re: materialize view logs rfresh [message #658139 is a reply to message #658080] |
Mon, 05 December 2016 08:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
The way an MVIEW log works is that a pointer to the changed row is put into the log for each MVIEW that references the table. When a refresh of the MVIEW is run, the rows are removed from the MVIEW log as the MVIEW is refreshed.
|
|
|