CODEWITHSUNDEEP
sqloracle-databaseddl
Charmi
Charmi

Reputation: 610

Cannot remove constraints

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

Upvotes: 5

Views: 4380

Answers (3)

SyMo7amed
SyMo7amed

Reputation: 378

you need to disable the oracle recyclebin, delete the object and then enable it again

ALTER SYSTEM SET recyclebin = OFF;
--delete object
ALTER SYSTEM SET recyclebin = on;

Upvotes: 1

gvenzl
gvenzl

Reputation: 1891

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.

Upvotes: 10

Mureinik
Mureinik

Reputation: 312136

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

Upvotes: 5

Related Questions