Re: Help. NT script required to recompile Oracle Objs, urgently !.
From: Mike Morgan <mmorgan1_at_mail.tds.net>
Date: Wed, 27 Oct 1999 01:35:49 GMT
Message-ID: <VFsR3.19$2P1.11205_at_ratbert.tds.net>
Date: Wed, 27 Oct 1999 01:35:49 GMT
Message-ID: <VFsR3.19$2P1.11205_at_ratbert.tds.net>
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 Wed Oct 27 1999 - 03:35:49 CEST