On Nov 20, 2:56 pm, ngarima..._at_gmail.com wrote:
> 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(*)
> ----------
> 1
>
> 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
try select count(1) from dual;
may be you have a null value
Received on Wed Nov 21 2007 - 06:25:46 CST
