Script for Compiling Invalid Objects

Comments
-
You could also just log in as sys and do 'exec utl_recomp.recomp_serial'.0
-
You could also just log in as sys and do 'exec utl_recomp.recomp_serial'.
I would rather the OP just use utlrp as a sysdba. Oracle provides and recommends the use of this script.HTH -- Mark D Powell --
HTH -- Mark D Powell --
0 -
I would rather the OP just use utlrp as a sysdba. Oracle provides and recommends the use of this script.
Hello.HTH -- Mark D Powell --
Since I have had issues with using utlrp in the past, I choose to go with something that consistently works.
0 -
I don't know, but in your script you may take into account the case of
alter package <object_name> view;
0 -
I don't know, but in your script you may take into account the case of
Hi,
alter package <object_name> view;
alter package <package_name> compile; (package specification)
alter package <package_name> compile body; (package body)both should have to take care .
Thanks,
Shrikant
0 -
Hi,
Hi,alter package <package_name> compile; (package specification)
alter package <package_name> compile body; (package body)both should have to take care .
Thanks,
Shrikant
his script looks like that it already takes into account this two cases. But "view" is missing.
0