创建oracle快照时报PLS-00201:

SQL> exec dbms_workload_repository.create_snapshot;

BEGIN dbms_workload_repository.create_snapshot; END;

 

      *

第 1 行出现错误:

ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_WORKLOAD_REPOSITORY' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

 

 

解决方法：没有给登陆用户执行exec dbms_workload_repository的权限；

用sysdba账号登陆执行：

grant execute on  dbms_workload_repository to TEST;