Patent 7895186 was granted and assigned to Oracle on February, 2011 by the United States Patent and Trademark Office.
A method and system for updating both partition change track tables and non-partition track tables in a materialized view. A log-based incremental refresh is performed on the materialized view and a partition change tracking based refresh is performed on the materialized view. The dependency of the materialized view log for the partition change track base table is removed.