建DBMS_SHARED_POOL

10.2.0.4中 
'DBMS_SHARED_POOL 这个包不存在， 用
SQL> exec DBMS_SHARED_POOL.KEEP('SONG.FN_GETPOLICY') ;
BEGIN DBMS_SHARED_POOL.KEEP('SONG.FN_GETPOLICY') ; END;


      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_SHARED_POOL.KEEP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored




SQL> @$ORACLE_HOME/rdbms/admin/dbmspool.sql


Package created.




Grant succeeded.




View created.




Package body created.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25099483/viewspace-1061580/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25099483/viewspace-1061580/