Oracle Data Pump Detailed (3) IMPDP

Import Mode

As with the export mode, the following 5 modes are mutually exclusive.

Full mode

Set Full=yes, if there is no datapump_imp_full_database role, can only be imported into the data under their own schema

Schema schema

Sets the schema parameter, which is the following syntax

Schemas=schema_name [,...]

The following example imports HR data into the HR schema

> IMPDP hr schemas=hr directory=dpump_dir1 logfile=schemas.log

Dumpfile=expdat.dmp

Table mode

Sets the table parameter, which is the following syntax:

Tables=[schema_name.] table_name[:p Artition_name]

If schema_name is not specified, the default representation is to import the current user's schema, such as:

> IMPDP hr directory=dpump_dir1 dumpfile=expfull.dmp tables=employees,jobs

You can also import the specified partition:

> IMPDP hr directory=dpump_dir1 dumpfile=expdat.dmp

tables=sh.sales:sales_q1_2012,sh.sales:sales_q2_2012

Tablespace mode

Set the Tablespace parameter with the following syntax:

Tablespaces=tablespace_name [, ...]

The following is an example of what to note: The tablespace to be imported must already exist, or the import will fail.

> IMPDP hr directory=dpump_dir1 dumpfile=expfull.dmp tablespaces=tbs_1,tbs_2,tbs_3,tbs_4

Transpotable tablespace mode

Set the Transpotable_tablespace parameter, whose syntax is defined as follows:

Transport_tablespaces=tablespace_name [, ...]

Only the metadata for the table space is imported, the data file needs to be copied to the native server at the operating system level, the path is specified by Transport_datafiles, and the syntax is as follows:

Transport_datafiles=datafile_name

Here is a concrete example:

Directory=dpump_dir1

Network_link=source_database_link

transport_tablespaces=tbs_6< P>transport_full_check=no

transport_datafiles= ' user01/data/tbs6.dbf '