Re: NO DATA FOUND >>> IN MULTI MASTER ???? (URGENT!!)

Here's is a statement on this subject from Oracle MetaLink:

    "Delete's can be problematic. There are several     different conflict conditions:

1. Attempt to delete an updated row
2. Attempt to delete a deleted row
3. Attempt to update a deleted row

    All three must be handled. It's possible to write     user-defined delete conflict resolution to handle     1 & 2. It's not possible to write user-defined     update conflict resolution to handle 3 (update     conflict resolution does not handle attempts to     update deleted rows -- it will handle updates to     updated rows). "

Isn't your situation the third one (update a deleted row)?

If your application is doing deletes it should rather mark records for deletion
and then some batch job should perform the actual delete.

Hope it helps!

Regards

Lars Bo Vanting
COREBIT SYAP/TPI AG, Switzerland
<naveen_arora_at_my-dejanews.com> schrieb in Nachricht 7abge6$b7f$1_at_nnrp1.dejanews.com...///
>hi,
>In a multi master configuration running ORACLE 7.3.2 among 3 masters.
>Following was observered :
>
>Lot of ORA 1403 No data found
>Update errors because old values not matching.
>
>Does default conflict resolution of ORACLE works fine implicitly ?
>My observations doesnot seem it is so.
>
>Thanks for any help.
>
>Naveen
>arora_n_at_hotmail.com
>naveen_at_cdotd.ernet.in
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Feb 16 1999 - 05:39:21 CST