Replicat Process Abends with Error OGG-00199 SYS_EXPORT_SCHEMA_01 Does Not Exist In Target Database (Doc ID 2208465.1)

Last updated on NOVEMBER 29, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.3 and later
Information in this document applies to any platform.

Symptoms

After export is taken using expdp and imported with impdp at target, replicat abends with below error:

2016-11-28 00:22:23 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, rep1.prm: Failed to retrieve column list handle for table SPS_SYS.SYS_EXPORT_SCHEMA_01.
2016-11-28 00:22:23 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, rep1.prm: Table SPS_SYS.SYS_EXPORT_SCHEMA_01 does not exist in target database.
2016-11-28 00:22:23 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.

Changes

 At source an export was taken using Data Pump utility.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms