Problem with purge recyclebin
SRI RAMSep 1 2010 — edited Sep 1 2010hi 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.