If the tablespace was created using OMF, you will have to use the value of DB_FILE_CREATE_
DEST and some detective work, or use the dynamic performance views V$DATAFILE and
596 Oracle Database 11g DBA Handbook
V$TABLESPACE, to track down the actual subdirectory and datafile name on the host operating
system.
Use impdp to Import Metadata
In the final step, you will run impdp on the target database to read the metadatafile and ???plug in???
the tablespace datafile. Here is the output from this operation:
[oracle@oc1 ~]$ impdp rjb/rjb directory=dest_dpump_dir
dumpfile=expdat.dmp transport_datafiles=/u05/oradata/xport_dw.dbf
Import: Release 11.1.0.6.0 -
Production on Sunday, 16 September, 2007 12:59:30
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition
Release 11.1.0.6.0 ??“ Production
With the Partitioning, Real Application Clusters, OLAP,
Data Mining and Real Application Testing options
Master table "RJB"."SYS_IMPORT_TRANSPORTABLE_01"
successfully loaded/unloaded
Starting "RJB"."SYS_IMPORT_TRANSPORTABLE_01": rjb/********
directory=dest_dpump_dir dumpfile=expdat.dmp
transport_datafiles=/u05/oradata/xport_dw.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "RJB"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 12:59:44
[oracle@oc1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.
Pages:
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879