ORA-20002: Version of statistics table dbms_stats.upgrade_stat_table

ORA-20002: Version of statistics table Please  try upgrading it with dbms_stats.upgrade_stat_table
procedure upgrade_stat_table(
ownname varchar2, stattab varchar2);

— Upgrade a user stat table from an older version

— Input arguments:
— ownname – The name of the schema
— stattab – The user stat table identifier

— Exceptions:
— ORA-20000: Unable to upgrade table



imp scott/tiger file=stats_table.dmp tables=stattable


SQL> exec dbms_stats.upgrade_stat_table(‘SCOTT’, ‘STATTABLE’);

SQL> exec dbms_stats.import_schema_stats(‘SCOTT’, ‘STATTABLE’);






沪公网安备 31010802001379号