OraFAQ Forum: Replication » Partitions in materialized views

Home » Server Options » Replication » Partitions in materialized views

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

�

Report message to a moderator

Previous Topic:	Create view
Next Topic:	Materialized View

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 12:13:04 CST 2025