If you are getting the error while dropping a tablespace, please follow the steps to solve the issue.
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.
Now you can create the tablespace without any error.
Pingback: ORA-19802: cannot use DB_RECOVERY_FILE_DEST