Data Pump (impdp and
expdp) replaces Import
(imp) and Export (exp)
Data Pump is a replacement for the
venerable IMP and EXP applications
used for creating logical backups of
Oracle tables, schemas or databases.
Data Pump is a server application (as
opposed to IMP and EXP, which were
client applications) which, in beta
testing, was twice as fast as the old
EXP for exporting data, and ten times
as fast as the old IMP for importing
data.
Data Pump is callable either
through the DBMS_DATAPUMP package,
through the replacements for IMP and
EXP, known as IMPDB and EXPDB, or
through a wizard delivered as part of
Oracle Enterprise Manager 10g.
Data Pump (and the new IMPDB and EXPDB
applications) offer a number of
improvements over the old IMPORT and
EXPORT, including resumable/restartable
jobs, automatic two-level parallelism,
a 'network mode' that uses DBLINKs/listener
service names instead of pipes,
fine-grained object selection (so you
can select individual tables, view,
packages, indexes and so on for import
or export, not just tables or schemas
as with IMPORT and EXPORT), and a
fully callable API that allows Data
Pump functionality to be embedded in
third-party ETL packages.
|
|
 |
|
Get the Complete
Oracle Utility Information
The landmark book
"Advanced Oracle
Utilities The Definitive Reference" contains over 600 pages of
filled with valuable information on Oracle's secret utilities.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
|
|
|
|
