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.
Changed Data Capture
Moderators: chulett, rschirm, roy
-
ian_bennett
- Participant
- Posts: 15
- Joined: Sun Sep 01, 2002 6:56 pm
- Location: Australia
- Contact: