impdp导入时出现了一下错误:
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
ORA-39014: One or more workers have prematurely exited.ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "PHSI"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at 01:29:59
运行df -h,发现根目录使用率100%了,当时用sys用户登录不进去,提示 no space,在根目录下删除两个文件,再次登录成功。
重新导入,又出现的如下错误:
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/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 6241
----- PL/SQL Call Stack -----
object line object
handle number name
0xddb3ce30 14916 package body SYS.KUPW$WORKER
0xddb3ce30 6300 package body SYS.KUPW$WORKER
0xddb3ce30 12279 package body SYS.KUPW$WORKER
0xddb3ce30 3279 package body SYS.KUPW$WORKER
0xddb3ce30 6889 package body SYS.KUPW$WORKER
0xddb3ce30 1262 package body SYS.KUPW$WORKER
0xddb2c3a8 2 anonymous block
Job "PHSI"."SYS_IMPORT_SCHEMA_02" stopped due to fatal error at 02:54:18
有人说是10.2.0.1的BUG,当时使用的版本如下:
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
统计信息不导入也没关系,我们可以导入后手动收集统计信息,可以在impdp中添加/TABLE_STATISTICS参数规避该错误。