C H A P T E R  13

images

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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial