1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Data Management
  4. Using Procedural Replication
  5. Enabling Procedural Replication

Enabling Procedural Replication

Procedural replication is disabled by default. You can enable it by setting the TRANLOGOPTIONS option, ENABLE_PROCEDURAL_REPLICATION, to yes.

Once you enable the procedural option for one Extract, it remains on and can not be disabled.
If you want to use Oracle GoldenGate in an Oracle Database Vault environment with procedural replication, then you must set the appropriate privileges.
To enable procedural replication:
  1. Ensure that you are in triggerless mode, see Prerequisites for Configuring DDL.
  2. Connect to the source database as an Oracle GoldenGate administrator with dblogin.
  3. Set the TRANLOGOPTIONS parameter option to yes.

    TRANLOGOPTIONS INTEGRATEDPARAMS (ENABLE_PROCEDURAL_REPLICATION Y)

Procedural replication is enabled for Extract.