Objects in RECYCLEBIN can't be purged
(Doc ID 1595081.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
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 |