建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.
'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博客 ” ，链接：https://blog.itpub.net/25099483/viewspace-1061580/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
