微信开发中 ACCESS TOKEN 过期失效的解决方案详解
234
2023-12-06
小编给大家分享一下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.sqlselect 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的示例代码”有了一定的了解,如果想了解更多相关知识,欢迎关注行业资讯频道,感谢各位的阅读!
版权声明:本文内容由网络用户投稿,版权归原作者所有,本站不拥有其著作权,亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容,请联系我们jiasou666@gmail.com 处理,核实后本网站将在24小时内删除侵权内容。
发表评论
暂时没有评论,来抢沙发吧~