So, yesterday I tried to use the exclude parameter in impdp/expdp to utilize the power of the data pump. Actually what I did was I didn't collect the statistics during expdp,
expdp
After this, the entire impdp task was very fast. The same exclude statistics can also be used in the impdp utility as given below,
impdp
But you should not use the exclude=statistics parameter if you have already done this during the expdp. It will throw an error "ORA-39168: Object path STATISTICS was not found."
The Data Pump is a good utility.
1 comment:
I see the same error even though I got statistics exported.
ORA-39168: Object path STATISTICS was not found.
Post a Comment