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’);
Leave a Reply