C H A P T E R  13


Data Pump

Data Pump was introduced in Oracle Database 10g. It replaces the older exp/imp utilities. Data Pump enables you to quickly move data and/or metadata from one environment to another. You can use Data Pump in a variety of ways:

  • Point-in-time logical backups of the entire database or subsets of data
  • Replicating entire databases or subsets of data for testing or development
  • Quickly generating Data Definition Language (DDL) required to re-create objects

Sometimes DBAs hold on to the old exp/imp utilities because they're familiar with the syntax and these utilities get the job done quickly. Even if those legacy utilities ...

Get Pro Oracle Database 11g Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.