Script for Compiling Invalid Objects

aschorr · Nov 12, 2009 5:53AM

user649511 · Nov 12, 2009 6:34AM

You could also just log in as sys and do 'exec utl_recomp.recomp_serial'.

Mark D Powell · Nov 12, 2009 6:38AM

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 --

aschorr · Nov 12, 2009 8:43AM

I would rather the OP just use utlrp as a sysdba. Oracle provides and recommends the use of this script.

HTH -- Mark D Powell --

Hello.

Since I have had issues with using utlrp in the past, I choose to go with something that consistently works.

user7443914 · Nov 12, 2009 8:36PM

I don't know, but in your script you may take into account the case of
alter package <object_name> view;

shrikant apune · Nov 12, 2009 8:43PM

I don't know, but in your script you may take into account the case of
alter package <object_name> view;

Hi,

alter package <package_name> compile; (package specification)
alter package <package_name> compile body; (package body)

both should have to take care .

Thanks,

Shrikant

user7443914 · Nov 12, 2009 9:50PM

Hi,

alter package <package_name> compile; (package specification)
alter package <package_name> compile body; (package body)

both should have to take care .

Thanks,

Shrikant

Hi,
his script looks like that it already takes into account this two cases. But "view" is missing.

Database Administration (MOSC)

Script for Compiling Invalid Objects

Comments

Category Leaderboard

Top contributors this month