Oracle GoldenGate uses the Oracle Data Pump utility to create new instances of a schema, table, user for the Oracle database. It works by unloading data and metadata into a set of operating system files that are called a dump file set.

This method uses the Oracle Data Pump utility to establish the target data. To run this method, you start Extract, the data pumps, and replicates at the SCN at which the copy stopped. Transactions that were included in the copy are skipped to avoid collisions from integrity violations. From the process start point, Oracle GoldenGate maintains data synchronization.

No initial-load Oracle GoldenGate processes are required for this method.

The following steps describe the process of setting up tables on the source database for replication to the target database using specific Oracle GoldenGate parameters and commands.