A-A+

DBMS_SHARED_POOL安装-PLS-00201: identifier ‘DBMS_SHARED_POOL.KEEP’ must be declared

2014年05月21日 BasicKnowledge 暂无评论 阅读 1,165 次
SQL> exec DBMS_SHARED_POOL.KEEP('STANDARD','P');
BEGIN DBMS_SHARED_POOL.KEEP('STANDARD','P'); 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

查看是否安装了DBMS_SHARED_POOL包

SQL> select count(*) from DBA_OBJECTS where object_name='DBMS_SHARED_POOL';

  COUNT(*)
----------
         0

安装DBMS_SHARED_POOL包

SQL> @?/rdbms/admin/dbmspool.sql

Package created.


Grant succeeded.


View created.


Package body created.

验证

SQL> select count(*) from DBA_OBJECTS where object_name='DBMS_SHARED_POOL';

  COUNT(*)
----------
         2

SQL> exec DBMS_SHARED_POOL.KEEP('STANDARD','P');

PL/SQL procedure successfully completed.

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: