Difference between revisions of "Script: Compile All Invalid Objects"
Jump to navigation
Jump to search
(Created page with "<pre> -- ======================================================================================== -- Compile all Invalid objects -- PACKAGE BODY: -- alter package owner.p...") |
|||
Line 7: | Line 7: | ||
-- All Others: | -- All Others: | ||
-- alter object_type owner.object_name compile; | -- alter object_type owner.object_name compile; | ||
− | -- | + | -- ======================================================================================== |
SELECT 'alter ' || decode(object_type,'PACKAGE BODY','PACKAGE',object_type) | SELECT 'alter ' || decode(object_type,'PACKAGE BODY','PACKAGE',object_type) | ||
|| ' ' || owner || '.' || object_name || ' compile ' | || ' ' || owner || '.' || object_name || ' compile ' |
Revision as of 05:26, 7 March 2011
-- ======================================================================================== -- 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';