Data Pump - Oracle 10g/11g Data and Database Management Utilities - page 5

• Full export mode: This mode exports the whole database; this requires the
user to have the exp_full_database role granted.
• Schema mode : This mode selects only specific schemas, all objects belonging
to the listed schemas are exported. When using this mode you should be
careful, if you direct a table to be exported and there are objects such as
triggers which were defined using a different schema, and this schema is not
explicitly selected then the objects belonging to this schema are not exported.
• Table mode : The tables listed here are exported, the list of tables, partitions,
and dependent objects are exported. You may export tables belonging to
different schemas, but if this is the case then you must have the exp_full_
database role explicitly granted to be able to export tables belonging to
different schemas.
• Tablespace mode : This mode allows you to export all tables belonging to
the defined tablespace set. The tables along with the dependent objects are
dumped. You must have the exp_full_database role granted to be able to
use this mode.
• Transportable tablespace mode : This mode is used to transport a
tablespace to another database, this mode exports only the metadata of the
objects belonging to the target set of listed tablespaces. Unlike tablespace
mode, transportable tablespace mode requires that the specified tables be
completely self-contained.
Data Pump Export provides different working interfaces such as:
• Command line interface : The command line interface is the default and
the most commonly used interface. Here the user must provide all required
parameters from the OS command line.
• Parameter ile interface : In this mode the parameters are written in a plain
text file. The user must specify the parameter file to be used for the session.
• Interactive command line interface . This is not the same interactive
command line most users know from the regular exp command. This
interactive command line is used to manage and configure the running jobs.