Clever Geek Handbook

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

+3


source to share


3 answers


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 .

+7


source


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
+5


source


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;
+1


source






More articles:


All Articles