Title: Object Level Orientation During Backup Using Data Pump
Publisher: Guru Nanak Publications
Series: Volume 3 Issue 2
Authors: Shivadeep.G, and Bhargava Chavali
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.
Backup, DB, EXPDP, IMPDP, Object, Parallelism.