Details: Can I replicate the following SQL statement to the target database with Oracle GoldenGate?
begin transaction read write; select * from schema.table where rowid=xxx for update; commit;
Answer: No, Oracle GoldenGate doesn't replicat this sql statement in general. The SELECT FOR UPDATE is meant to clock resources. For example, SELECT FOR UPDATE is used in one session (#1) to conserve the records so that NO other session (#2-999) can perform any DML operation on the selected data. At a later time, the original session (#1) can perform any required DML operation assuring that there was no change in between. The DML operation within the session (#1) are replicated by Oracle GoldenGate.
To achieve the same result on target, you can work used a GoldenGate Event Marker to trigger such SQL statements (SELECT FOR UPDATE) on the target database [1]. |
Thanks Volker for the help on this questions.
|
Resources
- 1451675.1: Oracle GoldenGate Best Practices: Dual Apply for GoldenGate.