A table mode export is specified using the TABLES
parameter. In table mode, only a specified set of tables, partitions, and their dependent objects are unloaded.
If you specify the TRANSPORTABLE=ALWAYS
parameter with the TABLES
parameter, then only object metadata is unloaded. To move the actual data, you copy the data files to the target database. This results in quicker export times. If you are moving data files between releases or platforms, then the data files may need to be processed by Oracle Recovery Manager (RMAN).
You must have the DATAPUMP_EXP_FULL_DATABASE
role to specify tables that are not in your own schema. Note that type definitions for columns are not exported in table mode. It is expected that the type definitions already exist in the target instance at import time. Also, as in schema exports, cross-schema references are not exported.
To recover tables and table partitions, you can also use RMAN backups and the RMAN RECOVER
TABLE
command. During this process, RMAN creates (and optionally imports) a Data Pump export dump file that contains the recovered objects. For more on this topic, see Oracle Database Backup and Recovery User's Guide.
"TABLES" for a description of the Export TABLES
parameter
"TRANSPORTABLE" for a description of the Export TRANSPORTABLE
parameter
Oracle Database Backup and Recovery User's Guide for more information on transporting data across platforms