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

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

You purge dba_recyclebin but the object is still there right?
IF so I m sending you the action plan:

1) sqlplus / as sysdba
2) purge dba_recyclebin;
3) ALTER SYSTEM SET recyclebin = OFF;
4) ALTER SYSTEM SET recyclebin = ON;

If the issue persist, send me the outputs.. (query outputs, command outputs and everyting) for further analysis.