A table-mode import is specified using the
TABLES parameter. In table mode, only the specified set of tables, partitions, and their dependent objects are loaded. The source can be a full, schema, tablespace, or table-mode export dump file set or another database. You must have the
DATAPUMP_IMP_FULL_DATABASE role to specify tables that are not in your own schema.
You can use the transportable option during a table-mode import by specifying the
TRANPORTABLE=ALWAYS parameter with the
TABLES parameter. Note that this requires use of the
NETWORK_LINK parameter, as well.
To recover tables and table partitions, you can also use RMAN backups and the RMAN
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.