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’);

 

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *