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 - 09:26:50 CST
