GoldenGate Initial Load Extract (instead Of Using Data Pump / Expdp) (Doc ID 3054734.1)

Last updated on OCTOBER 22, 2024

Applies to:

Goal

Using GoldenGate to replicate some Oracle Retail Merch SaaS tables to an external database (in Snowflake), using a GoldenGate BigData in a separate OCI tenancy.
- Can you please confirm that you can configure an "Initial Load Extract" on the MCS database GoldenGate (instead of using data pump / expdp) to generate the respective trail files and send them directly to the GoldenGate Target deployment?

Additional information:
The question is if you can create and configure an additional extract on the MCS DB GoldenGate.
This Extract is used to copy the existing contents of one or more tables from the source to the target database.
It would then send the trail files across directly to the Target GG deployment (no need to manually transfer the files, etc).
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.