My Oracle Support Banner

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

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


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