Re: cant drop any user

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 20 Nov 2007 10:02:22 -0800
Message-ID: <1195581734.377369@bubbleator.drizzle.com>

ngarimaldi_at_gmail.com wrote:

> 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

Because your syntax didn't come from Oracle. Where did you find it?

SQL> create user $USER identified by xxx; create user $USER identified by xxx

             *
ERROR at line 1:
ORA-00911: invalid character

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Nov 20 2007 - 12:02:22 CST