Monday, September 8, 2008

EXCLUDE and STATISTICS parameter in Export/Import Data Pump

Export/Import Data Pump is used to transfer data from one database to another or from one schema to another by using REMAP_SCHEMA. But sometimes it consumes a lot of time due to gather table statistics. We can minimize it by using this EXCLUDE parameter. Then we have to gather the statistics manually.

Example:
impdp prod/abc ....... exclude=statistics

No comments:

search engine

Custom Search