How Does Veridata Repair Job Interact With Triggers Present On Tables?
(Doc ID 2074961.1)
Last updated on MARCH 26, 2024
Applies to:
Oracle GoldenGate Veridata - Version 11.2.0.0.0 to 12.1.3.0.2 [Release 11.2 to 12.1]Information in this document applies to any platform.
Goal
How does the veridata repair job interact with triggers present on tables, for which data repair job is being run?
Scenario:
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?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |