//RECOMPILE.SQL文件内容
SET PAGESIZE 1000
SET LINESIZE 100
SET HEADING OFF
SPOOL ALT_ALLINVALID.SQL
SELECT 'SPOOL ALT_ALLINVALID_RESULT.txt' FROM DUAL;
SELECT 'ALTER VIEW '||OBJECT_NAME||' COMPILE;' FROM USER_OBJECTS WHERE OBJECT_TYPE='VIEW' AND STATUS='INVALID';
SELECT 'ALTER TRIGGER '||OBJECT_NAME||' COMPILE;' FROM USER_OBJECTS WHERE OBJECT_TYPE='TRIGGER' AND STATUS='INVALID';
SELECT 'ALTER PROCEDURE '||OBJECT_NAME||' COMPILE;' FROM USER_OBJECTS WHERE OBJECT_TYPE='PROCEDURE' AND STATUS='INVALID';
SELECT 'SPOOL OFF' FROM DUAL;
SPOOL OFF
@ALT_ALLINVALID.SQL
EXIT;