My Oracle Support Banner

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 to [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?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.