cant drop any user

From: <ngarimaldi_at_gmail.com>
Date: Tue, 20 Nov 2007 08:56:30 -0800 (PST)
Message-ID: <e41d368e-aac6-46c1-9034-eb0816fcfe74@s6g2000prc.googlegroups.com>

whem i try to drop any user or tbspaces i have the next error

drop user $USER CASCADE;
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2 ORA-01422: exact fetch returns more than requested number of rows

i check the sys.dual and it have 1 row

select count(*) from dual;

COUNT(*)

if i create a new user i can drop it, but cant drop the current users or tbspaces.

anyone can help me with this problem plz Received on Tue Nov 20 2007 - 10:56:30 CST