do u have ddl trigger on database ? if yes ... just check the script...
Deepa Kale -DBA
Jyoti Structures - Nasik(IT)
"Almyeed "
<oracledba-ezmlmshield-x55330257.[Email Address Removed] To: "LazyDBA Discussion" <[Email address protected]
azyDBA.com> cc:
Subject: Re: sys as sysdba connection [Urgent!!!!!]
16-07-2004 12:18 PM
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.
>
**************************************************************************
>
>
>
--------
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
Oracle LazyDBA home page