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.
Good trick..
any oracle support note for this