Shulou(Shulou.com)06/01 Report--

After each database upgrade, the objects in the library need to be recompiled. Here is a script that only needs to be executed to compile these failed objects in batches. It should be noted that due to permission problems, it is best to select sys users to execute this script. If it is executed in plsql developer, remember to select "ALL USERS".

[oracle@oracle] $cat check_compile.sql set heading off; set feedback off; set echo off; Set lines 999 Spool run_invalid.sql select 'alter' | | decode (object_type, 'VIEW',' VIEW','TRIGGER','TRIGGER',' PROCEDURE', 'PROCEDURE',' FOUNCTION','FUNCTION', 'PACKAGE','PACKAGE',' PACKAGE BODY', 'PACKAGE',' MATERIALIZED VIEW') | |' | owner | |'. | | object_name | | 'compile' | |'; 'from dba_objectswhere status like' INV%'; spool off; set heading on; set feedback on Set echo on; @ run_invalid.sql

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.