1.129 PROCEDURE

This is an option that can be specified as a stand-alone statement in extract and replicat parameter file. It indicates which feature group of procedural calls will be replicated.

Valid For

Extract and Replicat in Oracle only. It also requires the database to Oracle 12.2 or higher, and requires Oracle GoldenGate and the database to be configured appropriately. See Enabling Procedural Replication in Using Oracle GoldenGate for Oracle Database.

Syntax

PROCEDURE [ INCLUDE | EXCLUDE ]  FEATURE [ALL_SUPPORTED | feature_list]

Examples

Example 1   

Include all system supplied packages:

PROCEDURE INCLUDE FEATURE ALL_SUPPORTED

Example 2   

Include specific packages

PROCEDURE INCLUDE FEATURE AQ, FGA, DBFS

Example 3   

Exclude a specific packages

PROCEDURE INCLUDE FEATURE ALL_SUPPORTED
PROCEDURE EXCLUDE FEATURE REDFINITION