Compile All Objects
Jump to navigation
Jump to search
SELECT 'alter ' || DECODE(OBJECT_TYPE, 'PACKAGE BODY', 'PACKAGE', OBJECT_TYPE) || ' ' || OWNER || '.' || OBJECT_NAME || ' compile ' || DECODE(OBJECT_TYPE, 'PACKAGE BODY', 'BODY;', ';') FROM DBA_OBJECTS WHERE OBJECT_TYPE NOT IN ('TABLE', 'INDEX', 'SEQUENCE') AND OWNER IN ('SCHEMA')