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

 

 

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569