Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with purge recyclebin

SRI RAMSep 1 2010 — edited Sep 1 2010
hi all,
i am facing a new problem since today morning. please give me solution.. i.e i cannot purge the recyclebin, drop any table even as a dba also..

here is the problem.

SQL> select * from tab;

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BIN$s1U0QE0zT0CTJFuXOkMn9w==$0 TABLE
BONUS TABLE
CUSTOMER TABLE
DEPART TABLE
DEPT TABLE
DUMMY TABLE
EEE TABLE
EMPLOY TABLE
ITEM TABLE
LOC TABLE
ORD TABLE
PRICE TABLE
PRODUCT TABLE
SALES VIEW
SALGRADE TABLE

15 rows selected.

SQL> purge recyclebin;
purge recyclebin
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-01422: exact fetch returns more than requested number of rows


SQL> drop table bonus;
drop table bonus
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01422: exact fetch returns more than requested number of rows


thanks in regards.
rama raju.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2010
Added on Sep 1 2010
8 comments
1,115 views