Maintaining Materialized Query Tables
To maintain parity between source and target materialized query tables (MQT), you replicate the base tables, but not the MQTs. The target database maintains the MQTs based on the changes that Replicat applies to the base tables.
The following are the rules for configuring these tables:
-
Include the base tables in your
TABLE
andMAP
statements. -
Do not include MQTs in the
TABLE
andMAP
statements. -
Wildcards can be used in
TABLE
andMAP
statements, even though they might resolve MQT names along with regular table names. Oracle GoldenGate automatically excludes MQTs from wildcarded table lists. However, any MQT that is explicitly listed in an ExtractTABLE
statement by name will cause Extract to abend.