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

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

Prasad

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


Current Time: Thu Mar 28 15:58:12 CDT 2024