OCM 11g Preparation - Implement Data Pump export and import jobs for data transfer

Data Pump is one of the most basic things, but it has so many parameters that can transform in a complex thing.

Anyway, this utility is probably the most used tool for any DBA. So, try to focus during you training in the things that are not very common.

Be good exporting at tablespace / schema / database levels. Also, be ready to include or exclude something from backups (there are good DBA views to help you in those parameters as DATABASE_EXPORT_OBJECTS).

So, I would recommend you to study:

  • Parallelize your expdp with max file sizes.
  • Import inside a SQL file transforming and removing some STORAGE information.
  • Compress it (ALL, DATA_ONLY, [METADATA_ONLY]).
  • Attaching expdp or impdp command to jobs and than monitor and manage it (pause/resume the export).
  • Check and understand all "expdp help=y".
  • Check and understand all "impdp help=y".

Path to Documentation:

Utilities -> Part I Oracle Data Pump


Click here to go back to the Main OCM 11g Preparation page.

Have you enjoyed? Please leave a comment or give a 👍!

Leave a Reply

Your email address will not be published.