oracle 批量编译,Oracle 批量重新编译

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

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';