Goldengate DDL Replication Failed With ORA-38307: Object Not In RECYCLE BIN (Doc ID 2143973.1)

Last updated on NOVEMBER 18, 2016

Applies to:

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

Symptoms

 Hit below error:
2015-04-30 11:39:24 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, MGR.prm: Command received from GGSCI on host [10.14.232.19]:40432 (RESTARTSTATUS).
2015-04-30 11:39:54 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (gger): send manager restartstatus.
2015-04-30 11:39:54 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, MGR.prm: Command received from GGSCI on host [10.14.232.19]:40437 (RESTARTSTATUS).
2015-04-30 11:40:19 INFO OGG-00482 Oracle GoldenGate Delivery for Oracle, RT1000I2.prm: DDL found, operation [PURGE TABLE "CKI_SO"."BIN$ErZrml3WUO/gUxHoDgqSkA==$0" (size 53)].
2015-04-30 11:40:19 INFO OGG-00489 Oracle GoldenGate Delivery for Oracle, RT1000I2.prm: DDL is of mapped scope, after mapping new operation [PURGE TABLE "CKI_SO"."BIN$ErZrml3WUO/gUxHoDgqSkA==$0" (size 53)].
2015-04-30 11:40:19 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle, RT1000I2.prm: Setting current schema for DDL operation to [CKI_SO].
2015-04-30 11:40:19 INFO OGG-00484 Oracle GoldenGate Delivery for Oracle, RT1000I2.prm: Executing DDL operation.
2015-04-30 11:40:19 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, RT1000I2.prm: Fatal error executing DDL replication: error [Error code [38307], ORA-38307: object not in RECYCLE BIN SQL PURGE TABLE "CKI_SO"."BIN$ErZrml3WUO/gUxHoDgqSkA==$0" /* GOLDENGATE_DDL_REPLICATION */], no error handler present.
2015-04-30 11:40:24 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (gger): send manager restartstatus.
2015-04-30 11:40:24 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, MGR.prm: Command received from GGSCI on host [10.14.232.19]:40444 (RESTARTSTATUS).

Changes

 No changes

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