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

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

Did you drop an object recently?

 An object that is supposed to be used by PO_HEARDS_PKG_SO is dropped and it is in recycle bin now.

Check recycle bin. Look at ORIGINAL NAME    RECYCLEBIN NAME   columns.

See what is the original name of the recycle bin object named APPS.BIN$QyQ/t68DfB3gU4xyqMANqA==$0 ..

This may be a bug..

Send me the name of that object.. Then we ll see what to do next..

Our options are:
1)purge recycle bin..
2)take that object back from the recycle bin.