<<Previous Next>>
Oracle - What are data pump
Export and Import Modes? - Feb 07, 2010 at 14:20 PM by
Shuchi Gauri
What are data pump Export and Import Modes?
It is used for fast and bulk data movement
within oracle databases. Data Pump utility is faster than the
original import & export utilities.
Oracle - What
are data pump Export and Import Modes? - April 10, 2009
at 11:00 AM
What are data pump Export and Import
Modes?
Data pump export and import modes are used to determine the type
and portions of database to be exported and imported:
| Mode |
Mode Specification Parameter |
Description |
| Full |
FULL |
Exports and imports a full database. |
| Schema |
SCHEMA |
Enables you to export and import all objects that belong
to a schema |
| Table |
TABLES |
Enables you to export and import specific tables and
partitions |
| Tablespace |
TABLESPACES |
Enables a privileged user to move a set of tablespaces
from one Oracle database to another |
| Tablespace |
TRANSPORT_TABLESPACES |
Enables a privileged user to move metadata from the tables
within a specified set of tablespaces from one Oracle database
to another |
Also read
What are the use of Export and Import command?, What are the
parameters to be provided while executing Export and Import
commands?, What is the difference between the SQL*Loader and IMPORT
utilities?..............
Import and Export utilities are helpful in following ways: They
can be used for backup and recovery process, they can also be used
while moving database between two different...............
The import and export utilities of oracle provide a very simple
way to transfer data objects between Oracle databases. These may
reside on heterogeneous software and hardware.............
|
