一 现象描述
客户10g的数据库,使用数据泵进行导入时报错:
ORA-02298: cannot validate (SOFTOA.REFV3X_FILE1) - parent keys not found
Failing sql is:
ALTER TABLE "UFSOFTOA"."V3X_ATTACHMENT" ADD CONSTRAINT "REFV3X_FILE1" FOREIGN KEY ("FILE_URL") REFERENCES "UFSOFTOA"."V3X_FILE" ("ID") ON DELETE CASCADE ENABLE
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [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 95
ORA-06512: at "SYS.KUPW$WORKER", line 9001
二 原因分析
匹配到MOS上的文档:DataPump Import Including Statistics Terminates With Fatal Error ORA-39126