Database Administration (MOSC)
MOSC Banner

Drop tablespace throws error ORA-00604: error occurred at recursive SQL level 1 ORA-38301: can not

edited Aug 7, 2012 10:26PM in Database Administration (MOSC) 4 commentsAnswered ✓
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center