Recompile invalid objects

Recompile invalid objects

• 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();