Cannot remove constraints

Question

I have some strange constraints on strange table on my oracle database named BIN$DHUs7v8fwyvgUAB/AQAHZQ==$0

I cannot drop these constraints. I am getting the following error:

ORA-38301: Can not perform DDL/DML over objects in Recycle Bin

Answer 1

These are tables within the Recycle Bin of the database, with other words, those tables have been dropped. To purge them use:

purge recyclebin;

You can find more about the PURGE command in the Oracle Database documentation.

Answer 2

Oracle recycle bin is a special part of the data dictionary that stores removed objects in a fashion that allows them to later be recovered.

These objects (named BIN$unique_id$version, like the object in the question) can be manipulated directly, but instead should be purged from the recycle bin:

PURGE INDEX BIN$DHUs7v8fwyvgUAB/AQAHZQ==$0