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

Hi,

Sometimes You can get “ORA-38301: can not perform DDL/DML over objects in Recycle Bin ” error.

Details of error are as follows.

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

Cause: Tried to perform DDL or DML operation on Recycle Bin object.

Action: DDL or DML operations are not permitted on Recycle Bin objects.




SQL> drop tablespace RECOC1 including contents and datafiles;
drop tablespace RECOC1 including contents and datafiles
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

You can read the following post, if you don’t know what is the Recycle bin.

https://ittutorial.org/what-is-the-recycle-bin-and-how-to-restore-dropped-tables-from-recycle-bin/

You should disable the Recycle bin to solve this error.

SQL> ALTER SYSTEM SET RECYCLEBIN= OFF DEFERRED;

System altered.

Now try to drop the tablespace again.

SQL> drop tablespace RECOC1 including contents and datafiles;
Tablespace dropped.

You can enable the Recycle bin again as follows.

SQL > ALTER SYSTEM SET RECYCLEBIN = ON DEFERRED;

System altered.

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/