You
use the transport_tablespaces parameter on the expdp command line to specify the tablespaces.
Once you create the dump set with the metadata, you copy the datafiles for the tablespace(s) to
be transported to the destination server to be ???plugged in??? to the target database using impdp.
Later in this chapter, in the section ???Using Transportable Tablespaces,??? you will see how to
transport a tablespace from one database to another using directory objects, expdp, and impdp.
As with many of the other modes, transportable tablespace mode requires you to have the EXP_
FULL_DATABASE role.
Data Pump Import
Data Pump Import, or just Import, loads an export dump file set created with Data Pump Export
into a target system. Import is initiated at the operating system command line by using the impdp
command.
The modes available for Import match the modes in Export: Full Import, Schema, Table,
Tablespace, and Transportable Tablespace.
Chapter 16: Managing Large Databases 593
Full Import Mode
A full import uses the full parameter on the impdp command line. When you perform a full
import, the entire dump file set (or the entire database, when performing a network import
without a dump file set) is loaded into the target. You must have the IMP_FULL_DATABASE role
if you??™re importing another database directly or if the dump file set was exported using the EXP_
FULL_DATABASE role.
Schema Mode
You use the schemas parameter with impdp to import the objects in your own schema or, if you
have the IMP_FULL_DATABASE role, any number of schemas in the dump file set.
Pages:
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874