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

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

Read the following QA:

Why do objects owned by SYS show "no" in the CAN_PURGE column of dba_recyclebin?

This means that the particular object cannot be purged individually; e.g.,  using the 'PURGE
TABLE' or 'PURGE INDEX' syntax.  The 'PURGE DBA_RECYCLEBIN' command will  purge it, along with all the
dependent objects.

If these objects were purged, would those that have CAN_PURGE values of  "no" purge or be bypassed?
These objects will be purged when parent objects are purged.

Is there an option for a WHERE clause when running the 'PURGE DBA_RECYCLEBIN' command to code for CAN_PURGE='yes'?

No, there is not an option.  The command 'PURGE DBA_RECYCLEBIN' should purge all parent objects and its dependents.

By purging using the command 'PURGE DBA_RECYCLEBIN' on the objects that have can_purge="no", will this cause problems with any object in the database?

No. PURGE DBA_RECYCLEBIN won't cause problems with any objects in the database.