Re: cant drop any user

On 20 nov, 18:19, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Nov 20, 10:56 am, 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
>
> I want to see the entire shell script you're using to try to drop
> users.
>
> David Fitzjarrell- Ocultar texto de la cita -
>
> - Mostrar texto de la cita -

there isnt any script

just "drop user *USER* cascade;"

i cant drop any user Received on Tue Nov 20 2007 - 11:28:57 CST