import_schema_stats时报出ORA-20000:

今天在执行import_schema_stats报了如下错

SQL>@imp_schema_stats.sql

Session altered.

old   3:        wnname => '&u',
new   3:        wnname => 's500',
old   5:        statown => '&u');
new   5:        statown => 's500');
begin
*
ERROR at line 1:
ORA-20000: no statistics are imported
ORA-06512: at "SYS.DBMS_STATS", line 10604
ORA-06512: at line 2

经查，由于我把统计信息表dictstattab创建在s500下，所以在使用export出来的统计信息import时导致找不到dictstattab自身的统计信息，因此报错。换了import_table_stats后工作正常。

SQL> @delete_schema_stats.sql

Session altered.

old   2:   dbms_stats.delete_schema_stats('&user');
new   2:   dbms_stats.delete_schema_stats('s500');

PL/SQL procedure successfully completed.

SQL> @impstats_s500.sql


Session altered.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'CUSTOMER',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'DISTRICT',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'HISTORY',

PL/SQL procedure successfully completed.


old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'ITEM',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'NEW_ORDERS',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'ORDERS',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'ORDER_LINE',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'STOCK',

PL/SQL procedure successfully completed.

old   3:      wnname=>'&u',
new   3:      wnname=>'s500',
old   4:      tabname=>'&t',
new   4:      tabname=>'WAREHOUSE',

PL/SQL procedure successfully completed.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7734298/viewspace-680687/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7734298/viewspace-680687/