Configuration Controls Governor 5.5.x - Change Tracking Triggers Disable/Delete (Doc ID 1083861.1)

Last updated on FEBRUARY 26, 2015

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.

Goal

This document addresses the general guidelines and steps to be taken for Configuration Controls Governor (CCG) triggers while implementing database patches in Oracle R12.1 environment.

Question:
In order to properly implement database patches in a Oracle R12.1 environment, all triggers need to be removed. The Configuration Controls Governor (CCG) change tracking process creates triggers on the tables that are to be monitored. As a result, the patching process will require the removal of all CCG change tracking triggers, and then reapply them once the environment is back online. What is the best practice for removal and recreation of these CCG triggers?


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