ORACLE – Faire les compile des objects invalides
SET HEADING OFF SET FEEDBACK OFF; SPOOL C:INVALID.LIS SELECT 'ALTER '||DECODE(OBJECT_TYPE,'PACKAGE BODY','PACKAGE',OBJECT_TYPE) ||' '||OWNER||'.'||OBJECT_NAME||' COMPILE'||...
SET HEADING OFF SET FEEDBACK OFF; SPOOL C:INVALID.LIS SELECT 'ALTER '||DECODE(OBJECT_TYPE,'PACKAGE BODY','PACKAGE',OBJECT_TYPE) ||' '||OWNER||'.'||OBJECT_NAME||' COMPILE'||...
SPOOL c:analyze_tab.lis SELECT 'ANALYZE TABLE "' || OWNER || '"."' || TABLE_NAME || '" ESTIMATE...