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


ORA-39168: Object path STATISTICS was not found


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 - 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 - 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.


Remove EXCLUDE=STATISTICS parameter from the import job and run

If you like please follow and comment