* Connect to an Oracle database as user //sys// * Check to see how many objects are invalid: select count('e') from dba_objects where status='INVALID'; * Recompile all invalid objects: exec utl_recomp.recomp_serial();
select count('e') from dba_objects where status='INVALID';
exec utl_recomp.recomp_serial();