Materialized Views and Paritions in fact tables

[z1hou1]

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

[Ed Prochak]

To be honest, I do not know. Why don't you try it and find out?
You do have a test instance to run this in right????
ed

[joel garry]

This would seem to say yes, if you use the correct definitions, and
shows how to tell:
http://www.databasejournal.com/features/oracle/article.php/3633971/Oracle-10g-Materialized-View-Enhancements-Part-2.htm

jg
--
@home.com is bogus.
If at first you don't succeed, stay away from the rocks.
http://www.signonsandiego.com/photos/galleries/2009/dec/28/top-photos-week-dec-27-2009/3865/