Partition Change Tracking with Surprise

Partition Change Tracking (PCT) is a powerful feature in Oracle for fast refresh of materialized views when one of the base tables is partitioned. But under certain conditions, PCT does not work as expected and returns an unpleasant surprise.

Continue reading

Advertisements