小编给大家分享一下Compile invalids的示例代码,希望大家阅读完这篇文章之后都有所收获,下面让我们一起去探讨吧!cat compile_invalids. . ~/.prof
小编给大家分享一下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;
exit
EOSQL
看完了这篇文章,相信你对“Compile invalids的示例代码”有了一定的了解,如果想了解更多相关知识,欢迎关注编程网数据库频道,感谢各位的阅读!
--结束END--
本文标题: Compile invalids的示例代码
本文链接: https://www.lsjlt.com/news/69929.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0