2013年1月31日
ORA-20002: Version of statistics table dbms_stats.upgrade_stat_table
M
mac
Author
2 min
Read Time
13
Views
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’);