Oracle 12c 统计信息自动收集JOB-(BSLN_MAINTAIN_STATS_JOB)
报错信息
ORA-04063: package body "DBSNMP.BSLN_INTERNAL" has errors ORA-06508: PL/sql: could not find program unit being called: "DBSNMP.BSLN_INTERNAL" ORA-06512: at line 1
原因
Objects BSLN_INTERNAL is not in valid state
sqlplus / as sysdba sql> alter package DBSNMP.BSLN_INTERNAL compile body ; sql> GRANT EXECUTE ON sys.dbms_job to DBSNMP;原文链接:https://www.f2er.com/oracle/206521.html