檢視目前無效對象
select *
from dba_objects t
where t.status = 'INVALID' order by 1;
編譯無效對象:
有兩種方式:
1、執行sql查詢結果:
select 'alter '||object_type||' '||owner||'.'||object_name||' compile;'
from dba_objects t
where t.status = 'INVALID' order by 1;
2、腳本編譯:
sqlplus / as sysdba @?/rdbms/admin/utlrp.sql
本次分享到此結束啦~