Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete conflict resolution
speng_at_ncs.com.sg wrote:
>
> Does anyone knows how a write a user defined routine for delete conflict?
>
> I have a delete conflict problem here.
>
> My_tables
> ==========
> NRIC NOT NULL VARCHAR2(9)
> NAME NOT NULL VARCHAR2(30)
> SEX NOT NULL VARCHAR2(1)
> RACE NOT NULL VARCHAR2(1)
> LAST_UPDATE NOT NULL DATE
>
> If i have delete a row at local site and an update is done at the remote site.
> My problem here is it does not delete the record at the remote site due to the
> columns are update at the remote and the data is not found.
>
> Anyone has a sample user defined routine pls.
>
> Help!
>
> --
> Sok Peng
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
I've always found delete conflict resolution a nightmare (if not impossible)..
Rather than delete, why not have your app just update the row to a "delete" flag or have a "date_when_deleted" column. Then all you need update conflict routines which are easier to code (and also Oracle supply some samples)...
HTH --
![]() |
![]() |