ORA-39168: Object path STATISTICS was not found during datapump impdp

ORA-39168: Object path STATISTICS was not found during datapump impdp

Error:

ORA-39168: Object path STATISTICS was not found

REASON:

Expdp directory=DIR_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log schemas=SCHEMA_NAME exclude=statistics

export Done successfully without any errors

When trying the import the same into my target database

Impdp directory=DIR_NAME dumpfile=DUMPFILE_NAME.dmp logfile=LOGFILE_NAME.log  exclude=statistics

Import: Release 11.2.0.3.0 - Production on Fri Jan 20 16:15:14 2022

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39168: Object path STATISTICS was not found.

The error is because I already used the EXCLUDE=STATISTICS parameter during expdp job and again tried to exclude statistics again during the impdp operation, resulting in the error.

But we can use the EXCLUDE=STATISTICS parameter in the impdp(import) operation when we didn’t include this parameter in the export job.

Solution: 

Remove EXCLUDE=STATISTICS parameter from the import job and run

If you like please follow and comment