Object Level Orientation During Backup Using Data Pump

Title: Object Level Orientation During Backup Using Data Pump
Publisher: Guru Nanak Publications
ISSN: 2278-0947
Series: Volume 3 Issue 2
Authors: Shivadeep.G, and Bhargava Chavali


Abstract

Oracle Data Pump facilitates high-speed transfer of data and metadata from one database to another. This is the basis for the many Oracle Database data movement utilities. Data Pump Export (Export) is a utility for unloading data and metadata into a set of operating system files called dump file set. These files are made up of one or more binary files that contain original data, database object metadata, and control information. Data Pump Import (Import) is a utility for loading an exported set of dump files into a database. Import can also be used to load a destination database directly from a source database with no intermediate files, which allows export and import operations to run concurrently, minimizing total elapsed time. This paper discuss about architecture of data pump, limitation of export utility in case of single table restore using full backup and how table level orientation in dump files will help.

Keywords

Backup, DB, EXPDP, IMPDP, Object, Parallelism.

Download Full Text

(For complimentary copy, please contact Chief_editor@innovationjournals.com)