Home » Server Options » Replication » Partitions in materialized views
Partitions in materialized views [message #75483] Fri, 12 March 2004 00:04
Messages: 33
Registered: February 2004

I have a question about MV (materialized views).  I want to create a MV that is an aggregate of a fact table. This fact table is partitioned. I want to make an automatic refresh of the MV on commit on the fact table. In my DW app I control the data load to the fact table and dynamically add o split the partitions of the fact table. My MV must be also partitioned. I think that I ‘ll have to control MV partitions also, but is there any way of automatic control of the MV partitions on refrehs???

Any advice will be greatly aprecietted.

Previous Topic: Create view
Next Topic: Materialized View
Goto Forum:

Current Time: Sat May 21 13:16:24 CDT 2022