6.77 GGSCHEMA

Valid For

GLOBALS

Description

Use the GGSCHEMA parameter to specify the name of the schema that contains the database objects that are owned by Oracle GoldenGate, such as those that support DDL replication for trigger-based replication, those that are a part of the heartbeat table implementation, and those that are part of the SQL Server CDC Capture and Cleanup implementation.. The schema name mentioned under GGSCHEMA is treated as system object, and Table names with wildcards under the GGSCHEMA are excluded from the Extract. If you need to capture and replicate objects in GGSCHEMA, do not use wildcards and make sure that you explicitly map the respective table names.

See Establishing Oracle GoldenGate Credentials in Using Oracle GoldenGate for Oracle Databasefor more information about the Oracle GoldenGate database objects.

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