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 and later
Information in this document applies to any platform.


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.


 At source an export was taken using Data Pump utility.


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