Hey Guys,
Tested handlecollisions parameter in replicat and performed DML on source database
Results as follows ---
Tested handlecollisions parameter in replicat and performed DML on source database
Results as follows ---
scenario 1:
Replicat with no parameters
Test Results: Replicat is abended by throwing a discard
scenario 2:
Replicat with handle collisions
Test results:Replicat is ignoring transactions (no discard)
scenario 3:
Replicat with following parameters
reperror (0001,discard)
reperror (1403,discard)
BATCHSQL BATCHERRORMODE, BATCHTRANSOPS 100000
Test Results: Replicat throwing discard's and continuing :) ...
we will not get notified, when some thing is wrong with replication. Replicat will ignore transactions (no discard) and shows operation in stats indicates DML is performed on database, which is not true.
-Note--I never recommend to use handlecollisions in your replicat paramfile.
--Thank you
----Nikhil Tatineni---
----Oracle in memory---
we will not get notified, when some thing is wrong with replication. Replicat will ignore transactions (no discard) and shows operation in stats indicates DML is performed on database, which is not true.
-Note--I never recommend to use handlecollisions in your replicat paramfile.
--Thank you
----Nikhil Tatineni---
----Oracle in memory---