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

Posted by ErmanArslansOracleBlog on Dec 29, 2016; 7:34am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-38301-can-not-perform-DDL-DML-over-objects-in-Recycle-Bin-tp1825p1828.html

alter system set recyclebin=off;
drop that object
Retry your failing operation...

Then alter system set recyclebin=on;

If the issue persists; do the following;

1) sqlplus / as sysdba
2) ALTER SYSTEM SET recyclebin = OFF DEFERRED;
3) disconnect and exit sqlplus
4) sqlplus / as sysdba
5) drop THAT OBJECT
6(RETRY THE FAiling operation
7) sqlplus / as sysdba
8) ALTER SYSTEM SET recyclebin = ON DEFERRED; or ALTER SYSTEM SET recyclebin = ON;