- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 66 Insurance
- 536.8K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Oracle GoldenGate replication configuration - How to verify the
I have a schema.table1 with, among others, a field called "status" that can assume 'P' or 'A' or 'R' values.
I want all the records to be processed via Oracle GoldenGate replication except the updates of the field "status" in value 'A' or value 'P' if in the target schema.table1 the field "status" already contains the value 'R'.
In other words:
If target status is 'A' or 'P' accept the update of the entire transaction, else if target status is 'R' then accept only updates with status='R' and discard updates that would lead to 'A' or 'P' status.
I have a replicat that has a wildcard:
MAP schema.*, TARGET schema.*