DataPump Abends With OGG-02647 (Doc ID 3079801.1)

Last updated on APRIL 03, 2025

Applies to:

Oracle GoldenGate - Version 19.1.0.0.0 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.

Symptoms

DataPump process abends with OGG-02647 in an environment where the source database is in a multitenant configuration.

ggserr.log

2025-04-01T22:34:39.426+0000 WARNING OGG-02685 Oracle GoldenGate Capture for Oracle, pump01.prm: Ignoring SOURCECATALOG parameter <PDB> specified for TABLE parameter 'TABLE <PDB>.<Schema>.<Table2>, TARGET <Schema>.<Table3>' which contains a catalog specification.
2025-04-01T22:34:39.426+0000 INFO    OGG-02644 Oracle GoldenGate Capture for Oracle, pump01.prm: The catalog portion of source table name <PDB>.<Schema>.<Table2> in TABLE clause 'TABLE <PDB>.<Schema>.<Table2>, TARGET <Schema>.<Table3>' will not be written to trail file ./dirdat/rt.
2025-04-01T22:34:39.490+0000 ERROR   OGG-02647 Oracle GoldenGate Capture for Oracle, pump01.prm: Cannot specify table clause 'TABLE <PDB>.<Schema>.<Table2>, TARGET <Schema>.<Table3>' for trail file ./dirdat/rt because the trail specifies a different target table name format.
2025-04-01T22:34:39.511+0000 ERROR   OGG-01668 Oracle GoldenGate Capture for Oracle, pump01.prm: PROCESS ABENDING.

Changes

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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

DataPump Abends With OGG-02647 (Doc ID 3079801.1)

Applies to:

Symptoms

Changes

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!