mirror_journal_schema
Use this system parameter to enable multiple instances of CDC Replication to share the same trigger and journal table.
To enable this system parameter, you must specify the name of the journal that you want shared with another instance of CDC Replication. For example, if you have created an instance INSTANCE1 that specifies the journal SCHEMA1, and created another instance INSTANCE2 that specifies the journal SCHEMA2, then you would set the system parameter mirror_journal_schema on INSTANCE2 so that it points to the journal SCHEMA1. This enables both instances to share the same trigger and journal table. You can only set a value for this system parameter before mapping your tables and setting the subscription for mirroring. The value of this system parameter must refer to the name of an existing journal table.
- Applies to
- Source datastores
- Default Setting
- Not applicable