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
|
|
|