ORA-06521：執行dbms_stats.gather_table_stats報Error mapping function

 

ORA-06521: PL/SQL: Error mapping function

環境：oracle9.2.0.6

SQL> exec dbms_stats.gather_schema_stats('ys');

begin dbms_stats.gather_schema_stats('ys'); end;

ORA-06521: PL/SQL: 對映函式時出錯

ORA-06512: 在"SYS.DBMS_STATS", line 10070

ORA-06512: 在"SYS.DBMS_STATS", line 10564

ORA-06512: 在"SYS.DBMS_STATS", line 10751

ORA-06512: 在"SYS.DBMS_STATS", line 10805

ORA-06512: 在"SYS.DBMS_STATS", line 10782

ORA-06512: 在line 2

SQL> exec dbms_stats.gather_table_stats(user,'tb_family_info');

begin dbms_stats.gather_table_stats(user,'tb_family_info'); end;

ORA-06521: PL/SQL: 對映函式時出錯

ORA-06512: 在"SYS.DBMS_STATS", line 10070

ORA-06512: 在"SYS.DBMS_STATS", line 10084

ORA-06512: 在line 2

Just completing the thread with the solution.

Recompile the DBMS_STATS package :

源文件 <>

E:>sqlplus "/as sysdba"

SQL> alter package dbms_stats compile;

SQL> show errors

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

SQL> @?/rdbms/admin/prvtstas.plb

SQL> @?/rdbms/admin/prvtstat.plb

try it again

SQL>

SQL>

SQL> exec dbms_stats.gather_table_stats(user,'tb_family_info');

begin dbms_stats.gather_table_stats(user,'tb_family_info'); end;

ORA-04068: 已丟棄程式包 的當前狀態

ORA-04061: package "SYS.DBMS_STATS" 的當前狀態失效

ORA-04065: 未執行，已更改或刪除 package "SYS.DBMS_STATS"

ORA-06508: PL/SQL: 無法在呼叫之前找到程式單元

ORA-06512: 在line 2

SQL> exec dbms_stats.gather_table_stats(user,'tb_family_info');

PL/SQL procedure successfully completed

SQL> exec dbms_stats.gather_schema_stats('ys');

PL/SQL procedure successfully completed