-- ----------------------------------------------------------------------------------- -- File Name : http://oracle-base.com/dba/miscellaneous/compile_all_specs.sql -- Author : Tim Hall -- Description : Compiles all invalid package specifications for specified schema, or all schema. -- Call Syntax : @compile_all_specs (schema-name or all) -- Last Modified: 28/01/2001 -- ----------------------------------------------------------------------------------- SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER PACKAGE ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM all_objects a WHERE a.object_type = 'PACKAGE' AND a.status = 'INVALID' AND a.owner = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON