SOLVED

ORA-38301: Can Not Perform DDL/DML Over Objects In Recycle Bin

Asked by OracleDba••13 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
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
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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.

Hope it Helps!
OracleDba•

Post Your Solution