恢复完提示无效对象

批量重新编译过程包体,过程等

SELECT 'ALTER ' || object_type || ' ' || owner || '.' || object_name ||
       ' COMPILE;'
FROM dba_objects
WHERE status <> 'VALID';

重编译schema
execute utl_recomp.recomp_serial('SCOTT');

批量重新编译同义词

SELECT 'alter ' || decode(owner,
                          'PUBLIC',
                          'public synonym ',
                          'synonym ' || owner || '.') || object_name ||
       ' compile;'
FROM dba_objects
WHERE object_type = 'SYNONYM'
   AND status = 'INVALID';

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21302630/viewspace-1571537/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21302630/viewspace-1571537/