Oracle下查询无效的对象

jiawang

1、检查无效的数据库对象
select owner,object_name,object_type,status
from dba_objects
where status = 'INVALID';

2、检查不起作用的约束
select owner,constraint_name,table_name,constraint_type,status
from dba_constraints
where status = 'DISABLED';

3、检查无效的触发器
select owner,trigger_name,table_name,status
from dba_triggers
where status = 'DISABLED';

4、检查失效的索引
select  index_name,table_name,tablespace_name,status
from dba_indexes
where status <>'VALID';

解决办法：
执行@$ORACLE_HOME/rdbms/admin/utlrp.sql脚本编译数据库失效对象