My Oracle Support Banner

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

Last updated on MARCH 20, 2019

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 [xx.xx.xxx.xx]:<PORT> (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 [xx.xx.xxx.xx]:<PORT> (RESTARTSTATUS).
2015-04-30 11:40:19 INFO OGG-00482 Oracle GoldenGate Delivery for Oracle, <group>.prm: DDL found, operation [PURGE TABLE "<USER>"."BIN$xxxxxxxxxx/xxxxxxxxxxx==$0" (size 53)].
2015-04-30 11:40:19 INFO OGG-00489 Oracle GoldenGate Delivery for Oracle, <group>.prm: DDL is of mapped scope, after mapping new operation [PURGE TABLE "<USER>"."BIN$xxxxxxxxxx/xxxxxxxxxxx==$0" (size 53)].
2015-04-30 11:40:19 INFO OGG-01407 Oracle GoldenGate Delivery for Oracle, <group>.prm: Setting current schema for DDL operation to [<USER>].
2015-04-30 11:40:19 INFO OGG-00484 Oracle GoldenGate Delivery for Oracle, <group>.prm: Executing DDL operation.
2015-04-30 11:40:19 ERROR OGG-00519 Oracle GoldenGate Delivery for Oracle, <group>.prm: Fatal error executing DDL replication: error [Error code [38307], ORA-38307: object not in RECYCLE BIN SQL PURGE TABLE "<USER>"."BIN$xxxxxxxxxx/xxxxxxxxxxx==$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 [xx.xx.xxx.xx]:<PORT> (RESTARTSTATUS).

Changes

 No changes

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.