Page 1 of 1

Posted: Sun Sep 01, 2002 7:00 pm
by ian_bennett
The easiest way is to access the Logs for Oracle Materialized Views to identify the changes made to a table. These Logs are implemented as tables and can be created without needing to actually create the Materialized Views themselves.

I suggest reading the Oracle Data Warehousing Guide for more info on Materialized Views.