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 I tried:
SQL>ALTER SESSION SET RECYCLEBIN=OFF;
Thursday, November 12, 2009
ORA-38301: can not perform DDL/DML over objects in Recycle Bin
I noticed the below error while using drop user cascade;
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 I tried:
SQL>ALTER SESSION SET RECYCLEBIN=OFF;
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 I tried:
SQL>ALTER SESSION SET RECYCLEBIN=OFF;
Subscribe to:
Post Comments (Atom)
1 comment:
Thanks a lot !! You saved my day. I struggled to drop a user for 3 hours, then I got your solution. And it worked.
You are great !!!!
Post a Comment