Can't remove restrictions
I have some strange restrictions on a strange table in my oracle database named BIN$DHUs7v8fwyvgUAB/AQAHZQ==$0
I cannot give up these restrictions. I am getting the following error:
ORA-38301: cannot execute DDL / DML on objects in recycle bin
These are tables in the Recycle Bin of the database, in other words, these tables have been deleted. To clean them, use:
purge recyclebin;
You can find more information about the PURGE command in the Oracle Database documentation .
The Oracle Recycle Bin is a special part of the data dictionary that stores deleted objects so that they can be restored later.
These objects (named BIN$unique_id$version
like the object in the question) can be manipulated directly, but must instead be removed from the recycle bin :
PURGE INDEX BIN$DHUs7v8fwyvgUAB/AQAHZQ==$0
you need to disable oracle recyclebin utility, remove the object and then re-enable it
ALTER SYSTEM SET recyclebin = OFF;
--delete object
ALTER SYSTEM SET recyclebin = on;