- 08 Dec, 2023
- 0 Comments
- 33 Secs Read
ORA-38301: Can Not Perform DDL/DML Over Objects In Recycle Bin
Problem :
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.