PLS-00201: identifier ‘DBMS_LOCK‘ must be declared 编译失效对象报错

PLS-00201: identifier ‘DBMS_LOCK’ must be declared 编译失效对象报错

1、查看失效对象

select * from dba_objects where status!='VALID' and OWNER!='TUOMIN' order by TIMESTAMP DESC;

2、授权

grant execute on dbms_lock to 用户;

3、有用到dba_tab的赋权select

grant select on dba_tab_partitions to 用户;

失效对象中用到的表及用户需要以实际为准，具体使用PLSQL工具查询