Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: cant drop any user

Re: cant drop any user

From: <fitzjarrell_at_cox.net>
Date: Tue, 20 Nov 2007 09:19:31 -0800 (PST)
Message-ID: <86421b44-2cc1-4512-a679-c2cb182d43ee@f3g2000hsg.googlegroups.com>


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 Received on Tue Nov 20 2007 - 11:19:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US