1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SET ECHO OFF;
SET VERIFY OFF;
SET FEEDBACK OFF;
SET PAGESIZE 0;
SPOOL /tmp/recompile_objets.sql;
SELECT 'ALTER ' || RTRIM(object_type, ' BODY') || ' ' ||
object_name || ' COMPILE '||
DECODE (object_type,
'PACKAGE BODY','BODY;',
'PACKAGE', 'PACKAGE;',
';')
FROM user_objects
WHERE object_type IN ('PROCEDURE', 'FUNCTION', 'TRIGGER',
'VIEW','PACKAGE','PACKAGE BODY')
AND status = 'INVALID'
/
SPOOL OFF;
SET ECHO ON;
SET VERIFY ON;
SET FEEDBACK ON;
SET PAGESIZE 20;
@/tmp/recompile_objets.sql;
exit |
Partager