How Does Veridata Repair Job Interact With Triggers Present On Tables?
Last updated on JUNE 16, 2016
Applies to:Oracle GoldenGate Veridata - Version 184.108.40.206.0 to 220.127.116.11.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
How does the veridata repair job interact with triggers present on tables, for which data repair job is being run?
1) TABLE A has a insert trigger enabled on it.
2) Veridata job finds that 5 rows are missing on target and recommends running a repair job(which inserts 5 rows on target TABLE A).
3) When veridata inserts data on TABLE A, will it disable the trigger ??
4) If not, should the DBA disable trigger before veridata inserts this data?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms