Re: Help. NT script required to recompile Oracle Objs, urgently !.

Try:
select 'alter function '||object_owner||'.'||object_name||' compile;' from dba_objects where object_type='FUNCTION';

select 'alter procedure '||object_owner||'.'||object_name||' compile;' from dba_objects where object_type='PROCEDURE';

Then run the output of the above (repeating for packages etc.) JIm

jason <jfielding_at_trinitech.co.uk> wrote in message news:7v4bt3$aq8$1_at_trinitech.demon.co.uk...
> Hi,
> Could anyone please send me an example of an NT shell script to re-compile
> loads of packages, package bodies, views etc in one go. I did it on Unix a
> few years ago but can't find any examples and can't remember the syntax.
> Slightly urgent - trying to repair a DB.
> TIA
> Jason
>
>
>
Received on Tue Oct 26 1999 - 22:37:49 CEST