共计 868 个字符，预计需要花费 3 分钟才能阅读完成。
丸趣 TV 小编给大家分享一下 Compile invalids 的示例代码，希望大家阅读完这篇文章之后都有所收获，下面让我们一起去探讨吧！
cat compile_invalids.
. ~/.profile
sqlplus -s /nolog EOSQL
conn / as sysdba
set pages 0 lines 200 feed off
col object_name for a50
select Invalid Objects before compilation: ||chr(13) from dual;
select owner,object_name,object_type from dba_objects where status= INVALID order by 1,2;
select Total Invalid objects before compilation: ||count(*) from dba_objects where status= INVALID
@$ORACLE_HOME/rdbms/admin/utlrp.sql
@$HOME/scripts/compile_invalids.sql
select Invalid Objects after compilation: ||chr(13) from dual;
select owner,object_name,object_type from dba_objects where status= INVALID order by 1,2;
select Total Invalid objects after compilation: ||count(*) from dba_objects where status= INVALID
alter system flush shared_pool;
EOSQL看完了这篇文章，相信你对“Compile invalids 的示例代码”有了一定的了解，如果想了解更多相关知识，欢迎关注丸趣 TV 行业资讯频道，感谢各位的阅读！
正文完
