1、环境：
windows 2012 R2操作系统字符集：zhs16GBK
oracle 客户端字符集：zhs16GBK
oracle数据库字符集：al32UTF8
2、导入命令：
impdp mes_prd/123 dumpfile=MESPRD_20210106084942.DMP logfile=MESPRD_20210107LLL.log DIRECTORY=backup_mes SCHEMAs=mes_prd
IMPDP导入出现此问题：
ORA-39097: Data Pump job encountered unexpected error -1427
ORA-39065: unexpected master process exception in DISPATCH
ORA-01427: single-row subquery returns more than one row处理对象类型 SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
ORA-06502: PL/SQL: 数字或值错误
LPX-00225: end-element tag "HIST_GRAM_LIST_ITEM" does not match start-element tag "EPVALUE"
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPW$WORKER", line 9715
----- PL/SQL Call Stack -----
object line object
handle number name
00007FFA25493208 21979 package body SYS.KUPW$WORKER
00007FFA25493208 9742 package body SYS.KUPW$WORKER
00007FFA25493208 17950 package body SYS.KUPW$WORKER
00007FFA25493208 4058 package body SYS.KUPW$WORKER
00007FFA25493208 10450 package body SYS.KUPW$WORKER
00007FFA25493208 1824 package body SYS.KUPW$WORKER
00007FFA25495A58 2 anonymous block
ORA-39097: 数据泵作业出现意外的错误 -1427
ORA-39065: DISPATCH 中出现意外的主进程异常错误
ORA-01427: 单行子查询返回多个行
作业 "MES_PRD"."SYS_IMPORT_SCHEMA_01" 因致命错误于 星期三 1月 6 17:23:51 2021 elapsed 0 03:43:14 停止
3、可以去掉导入统计信息，再进行收集
impdp mes_prd/123 dumpfile=MESPRD_20210106084942.DMP logfile=MESPRD_20210107LLL.log DIRECTORY=backup_mes SCHEMAs=mes_prd EXCLUDE=STATISTICS
文章评论