OraFAQ Forum: Replication » URGENT ......MV needs to create

Home » Server Options » Replication » URGENT ......MV needs to create

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

URGENT ......MV needs to create [message #204183]

Sat, 18 November 2006 12:26

jai_sharma2001
Messages: 1
Registered: November 2006
Location: Gurgaon

Junior Member

Hi,
I have a table at 1 Master site which needs to be replicate at another 15 Materialized View site.

I want to create a MV at Materialized view site which update only Master site. But vice versa is not required.

MV site -> Master site (only -required)

I have tested updatable MV which update master site from the materialized view but it also updates rest of the 14 MV sites which I don't need. I dont know which MV needs to be created.

MV site -> Master site -> MV site (NOT REQUIRED)
...

Please help me here....Its URGENT.
regards
Jai
India

Report message to a moderator

Previous Topic:	Web links required
Next Topic:	ORA-23312

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 19:11:15 CST 2024