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