Databases Reference
In-Depth Information
Table Level
You can instruct Data Pump to operate on specific tables via the
TABLES
parameter. For example, say you want
to export
$ expdp mv_maint/foo directory=dp_dir dumpfile=tab.dmp \
tables=heera.inv,heera.inv_items
You should see some text in the output indicating that a table-level export is transpiring:
Starting "MV_MAINT"."SYS_EXPORT_TABLE_01...
Similarly, you can initiate a table-level import by specifying a table-level-created dump file:
$ impdp mv_maint/foo directory=dp_dir dumpfile=tab.dmp
A table-level import only attempts to import the tables and specified data. If a table already exists, an error is
thrown, and the import job continues. If a table already exists and contains data, you must specify how you want
the export job to handle this. You can have the import job either skip, append, replace, or truncate the table with the
TABLE_EXISTS_ACTION
parameter.
You can also initiate a table-level import when using a full-export dump file or a schema-level export. To do this,
specify which tables you want extracted from the full- or schema-level export:
$ impdp mv_maint/foo directory=dp_dir dumpfile=full.dmp tables=heera.inv
Tablespace Level
A tablespace-level export/import operates on objects contained within specific tablespaces. This example exports all
objects contained in the
USERS
tablespace:
$ expdp mv_maint/foo directory=dp_dir dumpfile=tbsp.dmp tablespaces=users
The text displayed in the output should indicate that a tablespace-level export is occurring:
Starting "MV_MAINT"."SYS_EXPORT_TABLESPACE_01"...
You can initiate a tablespace-level import by specifying an export file that was created with a tablespace-level
export:
$ impdp mv_maint/foo directory=dp_dir dumpfile=tbsp.dmp
You can also initiate a tablespace-level import by using a full export, but specifying the
TABLESPACES
parameter:
$ impdp mv_maint/foo directory=dp_dir dumpfile=full.dmp tablespaces=users
A tablespace-level import will attempt to create any tables and indexes within the tablespace. The import doesn't
try to recreate the tablespaces themselves.
■
Note
there is also a transportable tablespace mode export. See the section “Copying Data Files”, later in this chapter.
