My Oracle Support Banner

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

Last updated on DECEMBER 27, 2019

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 schemaname.SYS_EXPORT_SCHEMA_01.
2016-11-28 00:22:23 ERROR OGG-00199 Oracle GoldenGate Delivery for Oracle, rep1.prm: Table schemaname.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.


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.