Using Interactive-command Data Pump Export
In Data Pump export, you use the interactive-command
interface for one purpose only: when you decide you need to change
some export parameters midstream, while the job is still running.
Note that the export or import job keeps running throughout, without
any interruption.
This mode is enabled by pressing [Ctrl] + [C] during
an export operation started with the command-line interface or the
parameter file interface.
Using EM Database Control
Start the Database Control and go to the Maintenance
| Utilities page.
Data Pump Export Modes
o Full export mode: using FULL parameter
o Schema mode: using SCHEMAS parameter
o Tablespace mode: using TABLESPACES and/or
TRANSPORT_TABLESPACES parameters
o Table mode: using TABLES parameter
Data Pump Export Parameters - File and
Directory-Related Parameters
DIRECTORY - specifies the location of the dump and
other files.
DUMPFILE - provides the name of the dump file to
which the export dump should be written.
You can provide multiple dump filenames in several
ways:
o by specifying the %U substitution variable. Using
this method, the number of files you can create is equal to the
value of the PARALLEL parameter.
o using a comma-separated list.
o specifying the DUMPFILE parameter multiple times
FILESIZE - this optional parameter specifies size of
export file. The export job will stop if your dump file reaches its
size limit.
PARFILE - used to specify the parameter file. Every
parameter should be in a line.
Note: The directory object is not used by this
parameter. The directory path is an operating system specific
directory specification. The default is the user's current
directory.
LOGFILE and NOLOGFILE - You can use the LOGFLE
parameter to specify a log file
for your export jobs. If you don’t specify this parameter, Oracle
will create a log file
named export.log. If you specify the parameter NOLOGFILE, Oracle
will not create its log file.
Export Mode-Related Parameters
The export mode-related parameters are the FULL,
SCHEMAS, TABLES,
TABLESPACES, TRANSPORT_TABLESPACES, and TRANSPORT_FULL_CHECK
parameters. The TRANSPORT_FULL_CHECK parameter simply checks to make
sure that the tablespaces you are trying to transport meet all the
conditions to qualify for the job.
Export Filtering Parameters
CONTENT - It controls contents of exported data. The
possible values are:
o ALL exports data and definitions (metadata).
o DATA_ONLY exports only table rows.
o METADATA_ONLY exports only metadata (this is
equivalent to
rows=n ).
EXCLUDE and INCLUDE - Those are mutually exclusive
parameters. The EXCLUDE
parameter is used to omit specific database object types from an
export or import
operation. The INCLUDE parameter enables you to include only a
specific set of objects.
The syntaxes of using them are as follows:
