Drop tablespace throws error ORA-00604: error occurred at recursive SQL level 1 ORA-38301: can not
Hi,
Can any one please help me out to sort the issue. I am unable to drop the tablespace and the Oracle version is 10.2.0.4.
SQL> purge dba_recyclebin;
DBA Recyclebin purged.
SQL> alter tablespace db_maintenance offline;
Tablespace altered.
SQL> drop tablespace db_maintenance including contents and datafiles;
drop tablespace db_maintenance 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
I purged the recycle bin keeping the tablespace online however i am unable to drop it,
I can able to view the tablespace objects in the segments.
Can any one please help me out to sort the issue. I am unable to drop the tablespace and the Oracle version is 10.2.0.4.
SQL> purge dba_recyclebin;
DBA Recyclebin purged.
SQL> alter tablespace db_maintenance offline;
Tablespace altered.
SQL> drop tablespace db_maintenance including contents and datafiles;
drop tablespace db_maintenance 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
I purged the recycle bin keeping the tablespace online however i am unable to drop it,
I can able to view the tablespace objects in the segments.
0