昨天变更数据库的存储,由于不是24开启的数据库。所以就简单多了,全库冷备份。然后用impdp导入。但在导入到table_statistics时,出现如下错误,
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS while calling DBMS_METADATA.CONVERT [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 6313
导致impdp导入终止,致使job、trigger等未被导入,导入失败!
无奈下,放弃
TABLE_STATISTICS的导入,完成任务。
impdp system/password directory=dump_dir dumpfile=20110226.dmp full=y
exclude=TABLE_STATISTICS
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13726712/viewspace-688052/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13726712/viewspace-688052/