Re: how to disable Stored procedure

You gonna do some DBA work? after the question you just asked. Tell the developers to run for cover...

Anurag

"Rangesh Kona" <rkona_at_cadence.com> wrote in message news:3e315b3a$1_at_news.cadence.com...
> Actually I am trying to take a backup of all stored procedures but some of
> them are in invalid state and some are in valid state.
> I want to take a backup of these stored procedures as is and restore it
> after I do some DBA work.
> Thanks,
> Rangesh
>
>
> "Vsevolod Afanassiev" <vafanassiev_at_aapt.com.au> wrote in message
> news:4f7d504c.0301240209.514942c2_at_posting.google.com...
> > Rangesh,
> > I don't think it can be done easily.
> > If procedures are accessing tables in another schema,
> > then revoking access to these tables should do.
> > But if they are accessing tables in the same schema
> > you have to find something they depend on and
> > somehow damage these objects...
> >
> > In any case, Oracle tries to re-compile invalid objects
> > "on the fly", so even if you can find a way to invalidate
> > all objects in a schema, an attempt to use any of them
> > will automatically lead to re-compillation. If all objects
> > a procedure depends on have not been changed and all privileges
> > are still in place, the procedure will be re-compilled.
> >
> > What exactly are you trying to achieve?
>
>
Received on Fri Jan 24 2003 - 20:11:16 CST