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

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: Fri Mar 29 02:11:12 CDT 2024