What Are Data Pump Export And Import Modes?

1.	What Are Data Pump Export And Import Modes?
Answer» Data pump export and import MODES are used to determine the type and portions of database to be exported and IMPORTED. Oracle 10g SUPPORTS 5 export and import modes: Full: Exports and imports a full database. Use the FULL parameter to specify this mode. Schema: Enables you to export and import all OBJECTS that belong to a schema. Use the SCHEMAS parameter to specify this mode. This is the default mode. Table: Enables you to export and import specific tables and partitions. Use the TABLES parameter to specify this mode. Tablespace: Enables a PRIVILEGED user to move a set of tablespaces from one Oracle database to another. Use the TABLESPACES parameter to specify this mode. Tablespace: Enables a privileged user to move metadata from the tables within a specified set of tablespaces from one Oracle database to another. Use the TRANSPORT_TABLESPACES parameter to specify this mode. Data pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes:

Answer»

Data pump export and import MODES are used to determine the type and portions of database to be exported and IMPORTED.

Oracle 10g SUPPORTS 5 export and import modes:

Full: Exports and imports a full database. Use the FULL parameter to specify this mode.
Schema: Enables you to export and import all OBJECTS that belong to a schema. Use the SCHEMAS parameter to specify this mode. This is the default mode.
Table: Enables you to export and import specific tables and partitions. Use the TABLES parameter to specify this mode.
Tablespace: Enables a PRIVILEGED user to move a set of tablespaces from one Oracle database to another. Use the TABLESPACES parameter to specify this mode.
Tablespace: Enables a privileged user to move metadata from the tables within a specified set of tablespaces from one Oracle database to another. Use the TRANSPORT_TABLESPACES parameter to specify this mode.

Data pump export and import modes are used to determine the type and portions of database to be exported and imported.

Oracle 10g supports 5 export and import modes:

Discussion