Friday, June 21, 2013

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

Today while i'm trying to do schema import and i got an error below:

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

My export Done successful without any errors

Now, I’m 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 Jun 21 16:15:14 2013

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 EXCLUDE=STATISTICS parameter during expdp job and again trying to exclude statistics again during the impdp operation, and resulting in the error.
But we can use 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


Post a Comment

Auto Scroll Stop Scroll