File Library

The Oracle Data Pump API consists of a set of functions and procedures that provide a detailed, high-speed mechanism to move data and metadata between Oracle databases.
This presentation will examine which functions and procedures are available in the dbms_datapump package, and how they can be used to perform numerous functions. We will take a look at how to set up a Data Pump job and execute it. We will find out which objects, files and sessions get created when a Data Pump job runs. There will be an extensive discussion on the various data and metadata filtering options, and how certain parameters can help with a job’s performance. We will discuss how to interact with running jobs, and how to monitor them. We will also discuss how to move data in network mode without the need to create dump files.
A number of sample scripts will be made available to the audience. These scripts provide code examples for the various aspects of Data Pump, and can be executed in Oracle's scott/tiger sample schema.
At the end of the presentation, the audience should have a good idea of how to program the Data Pump API, and be aware of some of the pit falls it can have.