Difference between revisions of "Compile All Objects"
Jump to navigation
Jump to search
(Created page with "<pre> SELECT 'alter ' || DECODE(OBJECT_TYPE, 'PACKAGE BODY', 'PACKAGE', OBJECT_TYPE) || ' ' || OWNER || '.' || OBJECT_NAME || ' compile ' || DECODE(OBJECT_TYPE, 'PACKAGE...") |
(No difference)
|
Latest revision as of 14:54, 16 February 2012
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')
