While dropping a tablespace, getting error ORA-38301: can not perform DDL/DML over objects in Recycle Bin .

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

Before dropping the tablespace, disable recyclbin . 

1. Disable recyclebin:

SQL> ALTER SYSTEM SET recyclebin = OFF DEFERRED;

System altered.

2. Drop tablespace:

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

3.  Enable recyclebin 

SQL > ALTER SYSTEM SET recyclebin = ON DEFERRED;

System altered.