Performing an initial setup required for GoldenGate DDL replication
When GoldenGate is used for DDL replication, the Extract process on the source system requires some metadata tables. Hence, to enable the DDL replication in a source environment, you need to run some scripts to do an initial setup which, in turn, creates these metadata objects.
In this recipe, we will look at how to perform the initial setup required for enabling the DDL replication in a GoldenGate environment.
We will use the
GGATE_ADMIN schema for this setup.
How to do it...
Run the following scripts in the source environment:
- Change the directory to GoldenGate
- Log in to
sysdbaas shown in the following command:
sqlplus sys/**** ...