ORA-39168: Object path STATISTICS was not found.

ORA-39168: Object path STATISTICS was not found

此问题未回答。

ASulthan 2013-9-10 上午4:28

Hi 

While I m trying to do import schema level import and i got below error . how to resolve this below  error?

ORA-39168: Object path STATISTICS was not found 

expdp backup/backup directory=expdp_dir:schema_full.dmp logfile=schema_full.log

schemas=n4sparcs exclude=statistics

my export done successful with out any errors

Now i trying the import the same into my target machine or database

impdp backup/backup directory=expdp_dir:schema_full.dmp logfile=schema_full.log

schemas=n4sparcs exclude=statistics

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.

Any highly appericated

Thanks

• 137 查看
• 标签：
• 回复

平均用户评级: 无评分 (0 评级)

平均用户评级 

无评分

(0 评级) 

我的评级：                    

评分 差(1 / 5) 评分 中下(2 / 5) 评分 中等(3 / 5) 评分 中上(4 / 5) 评分 优(5 / 5)

• 1. Re:  ORA-39168: Object path STATISTICS was not found

  

  jf-Oracle 2013-9-10 上午3:05 （回复 ASulthan）

  Hi 
  Just remove this parameter from the import process   exclude=statistics, becasue the statistics were not export at all, hence the import utility is not going to find those in the dmp file. 
  
  New Command: 
  

  impdp backup/backup directory=expdp_dir:schema_full.dmp logfile=schema_full.log schemas=n4sparcs 
  

  
  Hope this helps.