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

You could run this:

declare cursor c is

   select distinct owner from dba_objects     where object_type in('PACKAGE','PACKAGE BODY','PROCEDURE','FUNCTION'); begin

    for r in c loop
      dbms_utility.compile_schema(r.owner);    end loop;
end;
/

Jason Judge wrote in message
<7v5eq7$d70$1_at_nclient13-gui.server.virgin.net>...
>Isn't there a DBMS package with procedures in that will recompile entire
>schemas in one go? It should be as simple as SQL> execute
>dbms_???.compile_all (or something like that).
>
>Regards,
>
>Jason Judge
>
>
>
Received on Tue Oct 26 1999 - 20:35:49 CDT