How Does Veridata Repair Job Interact With Triggers Present On Tables? (Doc ID 2074961.1)

Last updated on JUNE 16, 2016

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

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