Objects in RECYCLEBIN can't be purged (Doc ID 1595081.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2016***

Goal

Normal a table and all of its dependent objects (such as indexes, triggers) will be purge after perform purge command. However in some abnormal cases, running purge command return successful, but some dependent objects (such as indexes, triggers) cannot be purge properly.

For example:

SQL> purge dba_recyclebin;

DBA Recyclebin purged.

SQL> select object_name,original_name,type from dba_recyclebin;

OBJECT_NAME ORIGINAL_NAME TYPE
------------------------------- -------------------- ----------
BIN$4UFrbTF+BvXgRAAQ4A6lLg==$0 trigger90 TRIGGER
BIN$4UFrbTF9BvXgRAAQ4A6lLg==$0 trigger80 TRIGGER
BIN$4UFrbTF8BvXgRAAQ4A6lLg==$0 trigger75 TRIGGER
BIN$4UFrbTF7BvXgRAAQ4A6lLg==$0 trigger91 TRIGGER
BIN$4UFrbTF6BvXgRAAQ4A6lLg==$0 trigger81 TRIGGER
BIN$4UFrbTF5BvXgRAAQ4A6lLg==$0 trigger76 TRIGGER
BIN$4UFrbTF2BvXgRAAQ4A6lLg==$0 INDEX1 INDEX
BIN$4UFrbTF1BvXgRAAQ4A6lLg==$0 INDEX2 INDEX
BIN$4UFrbTF0BvXgRAAQ4A6lLg==$0 INDEX3 INDEX
BIN$4UFrbTFzBvXgRAAQ4A6lLg==$0 INDEX4 INDEX

Solution

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