DataPump Import (IMPDP) Fails With Error ORA-1427 During Importing Statistics

DataPump Import (IMPDP) Fails With Error ORA-1427 During Importing Statistics

Database Version : 11.2.0.4


Error Details:
During DataPump import, you encounter errors like:

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

Job "SYSTEM"."IMPORTJOB" stopped due to fatal error at Thu Mar 28 08:32:51 2019 elapsed 0 00:19:06

The import logfile shows:

0x242f2aec0      9742  package body SYS.KUPW$WORKER
0x242f2aec0     17950  package body SYS.KUPW$WORKER
0x242f2aec0      4058  package body SYS.KUPW$WORKER
0x242f2aec0     10450  package body SYS.KUPW$WORKER
0x242f2aec0      1824  package body SYS.KUPW$WORKER
0x242f2f300         2  anonymous block
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

Job "SYSTEM"."IMPORTJOB" stopped due to fatal error at Thu Mar 28 08:32:51 2019 elapsed 0 00:19:06

RCA:

There is an issue with the statistics in the export dump.

Solution:

Import with EXCLUDE=STATISTICS and gather the statistics after the import.

For Example:

more export.par

userid=system/A4moremoney

dumpfile=TEST%U.dmp

directory=dum_dir1

logfile=TEST_dump_exp.log

schemas=TEST

parallel=8

job_name=importtest

exclude=statistics