Major
functional components for Moving data in Oracle:
•DBMS_DATAPUMP:
Contains the API for high-speed export and import utilities for bulk data and
metadata movement
•Direct
Path API
(DPAPI):
Oracle Database 11g
supports a Direct Path API interface that minimizes data conversion and parsing
at both unload and load time.
•DBMS_METADATA: Used
by worker
processes for all metadata unloading and loading. Database object definitions
are stored using XML rather than SQL.
•External
Table API:
With the ORACLE_DATAPUMP and ORACLE_LOADER
access drivers, you can store data in external tables (that is, in
platform-independent files). The SELECT statement reads external tables as
though they were stored in an Oracle database.
•SQL*Loader: Has
been integrated with external tables, providing automatic migration of loader
control files to external table access parameters
•expdp and impdp: Thin layers that make calls to the
DBMS_DATAPUMP
package to initiate and monitor Data Pump operations
•Other
clients:
Applications (such as Database Control, replication, transportable tablespaces, and
user applications) that benefit from this infrastructure. SQL*Plus may also be
used as a client of DBMS_DATAPUMP for
simple status queries against ongoing operations.