hii deepa,

there are many triggers created but how can i find which one is it???

thanks
Almyeed

----- Original Message -----
From: "Deepa S. Kale " <[Email address protected]
To: <[Email address protected]
Sent: Friday, July 16, 2004 12:44 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
>
>
>
> 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] "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