Re: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
Posted by Jason on Dec 29, 2016; 7:31am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ORA-38301-can-not-perform-DDL-DML-over-objects-in-Recycle-Bin-tp1825p1827.html
object name is XXPO_KN_EARN_SS_UPD which is APPS.BIN$QyQ/t68DfB3gU4xyqMANqA==$0(this is trigger)
but WE PURGED that and also we purged dba_recycle but useless still we are seeing in recycle.
No we didnt drop that but in 8 Dec someone did.We created trigger again from our TEST database ,but users still getting same errors,and we are seeing same error in alertlog