Replicat Process Abends with Error OGG-00199 SYS_EXPORT_SCHEMA_01 Does Not Exist In Target Database
Last updated on NOVEMBER 29, 2016
Applies to:Oracle GoldenGate - Version 220.127.116.11.3 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