GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

How to specify multiple GGSCHEMAs?

  • Extract: Use the schema name in each PDB. Each PDB with which the Extract is registered should have its own heartbeat table. To instruct Extract which schema to find the heartbeat tables in, use GGSCHEMA pdb.schemaname within the GLOBALS file.

Syntax

GGSCHEMA [container.]schema_name


Given the above how exactly do you go about specifying multiple GGSCHEMAS for use with multitenant? What if I want to use goldengate across a mixture of non-CDB and CDB sources?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center