Valid For

GLOBALS

Description

Use this parameter to specify the name of the schema that contains Oracle GoldenGate database objects, such as those that support Oracle DDL replication for trigger-based replication, those that are a part of a heartbeat table implementation, and those that are part of the SQL Server CDC Capture and Cleanup implementation.

The schema name mentioned under GGSCHEMA should be treated as a reserved schema and should not be used as part of a TABLE or MAP statement within an Extract, Pump, or Replicat. If you need to capture and replicate objects in GGSCHEMA, don't use wildcards and ensure that you explicitly map the respective table names. It's recommended that you take assistance from Oracle Support to make any changes including any CREATE, ALTER, or DROP of objects in this schema.

This parameter is valid for all databases.

See Other Requirements for Multitenant Container Databases Using Oracle GoldenGate for Oracle Database to know more about using the GGSCHEMA parameter.

Default

None

Syntax

GGSCHEMA [container.]schema_name

[container.]schema_name

The fully qualified name of the Oracle GoldenGate objects' schema. Use the full two-part name if the schema is within an Oracle container database.

Example

GGSCHEMA ogg