Materialized Views and Paritions in fact tables

From: z1hou1 <z1hou1_at_gmail.com>
Date: Mon, 28 Dec 2009 18:54:53 -0800 (PST)
Message-ID: <faa217dc-92a0-4581-b248-2e10fe59e75d_at_b2g2000yqi.googlegroups.com>



Hi,
I have a situation where I have a materialized view/log to refresh on commit on a fact table that is subject to archive considerations. The fact table is partitioned by date range.

Now, the materialized view has very few rows and therefore not partitioned.

My question is, if older partitions in the fact table are dropped because of an archiving exercise, what will be the state of the materialized view that was based on a view log set to refresh on commit.

Thanking you and regards,
z1hou1 Received on Mon Dec 28 2009 - 20:54:53 CST

Original text of this message