Script: Compile All Invalid Objects

-- ========================================================================================
-- Compile all Invalid objects
--       PACKAGE BODY:
--			alter package owner.package_body_name compile BODY;
--
--	   All Others:
--			alter object_type owner.object_name compile;
-- ========================================================================================
SELECT 'alter ' || decode(object_type,'PACKAGE BODY','PACKAGE',object_type) 
|| ' ' || owner || '.' || object_name || ' compile ' 
|| decode(object_type,'PACKAGE BODY','body','') || ';'
FROM dba_objects
WHERE status <> 'VALID';