materialize view logs rfresh [message #658076] |
Fri, 02 December 2016 09:37 |
|
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 |
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.
|
|
|