Blog

SQL> drop tablespace USER_TBS including contents and datafiles;
drop tablespace USER_TBS 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

Solution:

You have to disable recyclebin before dropping the tablespace to resolve the error:

1. Disable recyclebin:

SQL> ALTER SYSTEM SET recyclebin = OFF DEFERRED;

System altered.

2. Drop tablespace:

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

3.  Enable recyclebin:

SQL > ALTER SYSTEM SET recyclebin = ON DEFERRED;

System altered.