DST Upgrade Failing With BIN$ Objects even though no objects in recyclebin (Doc ID 3073841.1)

Last updated on FEBRUARY 25, 2025

Applies to:

Symptoms

DST upgrade is getting failed with below error even though there is no objects in recyclebin. For this customer it was 19.25 but these steps applicable in 19c releases.


SQL> BEGIN
  2 DBMS_DST.UPGRADE_DATABASE(:numfail,
  3 parallel => TRUE,
  4 log_errors => TRUE,
  5 log_errors_table => 'SYS.DST$ERROR_TABLE',
  6 log_triggers_table => 'SYS.DST$TRIGGER_TABLE',
  7 error_on_overlap_time => FALSE,
  8 error_on_nonexisting_time => FALSE);
  9 DBMS_OUTPUT.PUT_LINE('Failures:'|| :numfail);
 10 END;
 11 /
Table list: "OFM_DEV"."BIN$zG5oqiMLHTngU5jcSKgC8w==$0"
BEGIN
*
ERROR at line 1:
ORA-38301: can not perform DDL/DML over objects in Recycle Bin
ORA-06512: at "SYS.DBMS_DST", line 1131
ORA-06512: at "SYS.DBMS_DST", line 611
ORA-06512: at "SYS.DBMS_DST", line 209
ORA-06512: at "SYS.DBMS_DST", line 858
ORA-06512: at "SYS.DBMS_DST", line 596
ORA-06512: at "SYS.DBMS_DST", line 1123
ORA-06512: at line 2

we have tried the manual cleanup with document Doc ID 2970537.1

Post that we were seeing only indexes there with bin$. while trying to cleanup the indexes its failing below error, on rerun of DST upgrade its still failing even tough the tables are not there in db with bin$ name.
14:56:58 SQL> select segment_type,count(*) from dba_segments where segment_name like 'BIN%' group by segment_type;

SEGMENT_TYPE COUNT(*)
------------------ ----------
INDEX 21


15:07:21 SQL> drop index <OWNER>."BIN$0ORsTMYEJb3gU5jcSKgEMQ==$0";
drop index <OWNER>."BIN$0ORsTMYEJb3gU5jcSKgEMQ==$0"
  *
ERROR at line 1:
ORA-02429: cannot drop index used for enforcement of unique/primary key

Changes

No changes are done

Cause

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