Updating table using materialized view
947561Jul 6 2012 — edited Jul 13 2012Hi,
I have a table testing_mview on which I have created materialized view log and a materialized view mv. whenever there is a DML operation on testing_mview on commit it reflects to 'mv'.
But my requirement is that a DML operation on testing_mview should reflect to another table testing_mview_1 over a database link using materialized view log. Please let me know how to achieve this.