Hi there ,

Below is the error what i get...............

SQL> drop user abc cascade;
drop user abc 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
ORA-06512: at line 13

any help????

----- Original Message -----
From: "SivaMurugesh_Arumugam " <[Email address protected]
To: <[Email address protected]
Sent: Friday, July 16, 2004 12:08 PM
Subject: RE: sys as sysdba connection [Urgent!!!!!]


> **A LazyDBA.com subscriber has responded to your lazydba.com post**
> **LazyDBA.com mail shield has forwarded you this email,
> **and removed any attachments, and kept your email address secret
> **from this person, and any viruses/trojans.
> **If you reply to this email, the person will see your email address as
normal
> **Anything below this line is the original email text
>
>
> What error do you get exactly????
>
> -----Original Message-----
> From: Almyeed
> [mailto:oracledba-ezmlmshield-x50938171.[Email address protected]
> Sent: Friday, July 16, 2004 11:57 AM
> To: LazyDBA Discussion
> Subject: sys as sysdba connection [Urgent!!!!!]
>
>
> Hi All,
>
> There is a problem with our sys as sysdba connection(Orcale9i rel1
win2k
> box). when i try to grant some permission to an X user it gives me an
> recurssive error? what could be the resolution for the same?
>
> thanks
> Almyeed
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
> **************************************************************************
> This email (including any attachments) is intended for the sole use of the
> intended recipient/s and may contain material that is CONFIDENTIAL AND
> PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
> distribution or forwarding of any or all of the contents in this message
is
> STRICTLY PROHIBITED. If you are not the intended recipient, please contact
> the sender by email and delete all copies; your cooperation in this regard
> is appreciated.
> **************************************************************************
>
>
>

Oracle LazyDBA home page