I would like to finish this chapter talking very briefly about how you can improve the performance of your export and import operations. My recommendations are:
Always exclude statistics:
Exporting and importing statistics were very slow since the introduction of Data Pump (10.1)
Exclude from export when possible or if included in the export; exclude them in the import operation
Regenerate the statistics after the import operation is completed
Use Parallelism (requires Enterprise Edition and extra license for this option):
Use as many resources available to improve Data Pump performance when loading or unloading data
Remember it can be changed dynamically any time you need using the interactive-command mode; make parallel higher during no-peak times and lower when on peak time
Never forget to use the wildcard for dump file generation (
%U) when using parallelism
Use Transportable Tablespaces or Full Transportable Export/Import (as we have seen in Chapter 3, What is New...