Home » Server Options » Replication » Materilized view group order
Materilized view group order [message #75485] Tue, 16 March 2004 01:11
Messages: 104
Registered: October 2000
Senior Member

I have to replicate 12 tables which is having referential integrity constraints . I put all these tables on one group and refreshing at one shot only problem is while insert operation it works fine since parent record insert followed by child but for deleting it throws referential intregriity failure. Since the I put the parent first and child table next in materilized view group. So what is the alternate solution for this

1) To create separate materlized view group one for insert operation  and separate materlized view group for delete operation

2) To disable refrential intregrity constraints while refreshing and reenabling them after refresh so that refrential intregrity is ensured after refresh.

What is the other alternate options. Please let me know

Thanks in advance


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

Current Time: Sat May 21 14:08:07 CDT 2022