如何查看失效的对象

1. --执行以下SQL语句，可查询Procedure,Function,Package,Package Body,Trigger,View是否失效:
   
2. SELECT * FROM dba_objects a WHERE a.owner IN ('SYS'，'SYSTEM','ZLTOOLS','ZLHIS') AND a.status='INVALID';
   
3. 
   
4. --直接生成失效的对象的编译方式：
   
5. SELECT 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;'
   
6.   FROM ALL_OBJECTS
   
7.  WHERE STATUS = 'INVALID'
   
8.    AND OBJECT_TYPE IN ('PROCEDURE','FUNCTION', 'VIEW','TRIGGER','PACKAGE','PACKAGE BODY')
   
9.    AND OWNER IN ('SYS'，'SYSTEM','ZLTOOLS','ZLHIS');
   
10.                                                                
    
11. SELECT 'ALTER PACKAGE ' || OWNER || '.' || OBJECT_NAME || ' COMPILE BODY;' FROM ALL_OBJECTS WHERE STATUS = 'INVALID' AND OBJECT_TYPE = 'PACKAGE BODY';
    
12. 
    
13. --查看失效的index
    
14. SELECT * FROM Dba_Indexes a WHERE a.status='UNUSABLE' ;

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

转载于:http://blog.itpub.net/28878983/viewspace-2133928/