O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Pump files

Data Pump jobs manage few types of files; they are:

  • Dump files; these files contain all the data and metadata that is being moved (generated as per the DUMPFILE parameter input).
  • A log file that records all outputs related with an import or export operation (when using the LOGFILE parameter).
  • SQL files that contain the results of a SQLFILE operation (when using the SQLFILE parameter). In other words, this file will enclose a dump of all SQL DDL statements that import operations would execute without really executing the real import.
  • Datafile copies that will be used during a transportable import operation (specified in the DATA_FILE parameter).

Roles for Data Pump export and import

If you are required to perform export and import operations ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required