Table Mode
To import specific tables from a dump file set that contains either a full, schema, tablespace, or
table-only export operation, use the tables parameter with impdp. The source can also be another
database. If the tables you are importing are not in your schema, you must have the IMP_FULL_
DATABASE role.
Tablespace Mode
The parameter tablespaces is used at the impdp command line to import one or more tablespaces
into the current database. The source for the tablespace import can be a tablespace export, a full
database export, a schema export, a table-mode export, or another database.
Transportable Tablespace Mode
Using the transport_tablespaces parameter, you import the metadata from a transportable tablespace
export dump file set or another database. The transport_datafiles parameter references the location
where the datafiles for the transported tablespace are located.
Using Transportable Tablespaces
Transportable tablespaces make it easy to move large volumes of data between databases a
tablespace at a time; Oracle 10g provides a number of enhancements to transportable tablespaces,
making it easier to move data between databases that reside on different hardware and software
platforms. Data Pump Export and Import play key roles in transporting a tablespace between
databases.
NOTE
As of Oracle Database 10g, transportable tablespaces no longer need
to be marked read-only if you use an RMAN tablespace backup with
the RMAN transport tablepsace command to perform the transport;
the backup of the tablespace can therefore be performed while the
tablespace is open for read and write.
Pages:
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875