My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

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
Goal
Solution


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