-
Replication
Hi to All!
I would like to discuss some problem regarding Oracle Replication.
If you have two (2) sites and configure replication with both sites.
And if you update any row from one site and before applying other site you update from that site, then Oracle will reply as an error (no data found).
Because same row has been updated from both sites at a time.
For example: (Job interval time is 1 minute for both sites)
@ site 1: You issue this command.
update emp set job='DBA' where empno=3123;
@ site 2: You issue this command.
update emp set job='JTO' where empno=3123;
now when oracle server is going to apply this record, it gives following error.
ORA-01403:No data found.
Kindly check this and give me any resolution for this problem.
I look forward to all of you.
Best Regds
Farrukh.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|