e /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/datafile/o1_mf_system_9nspvcw5_.dbf deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/datafile/o1_mf_undotbs1_9nspvd37_.dbf deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/datafile/o1_mf_sysaux_9nspvcwv_.dbf deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/datafile/o1_mf_temp_9nsq2hbj_.tmp deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/onlinelog/o1_mf_1_9nsq1cmc_.log deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/onlinelog/o1_mf_2_9nsq1fq2_.log deleted
auxiliary instance file /u01/tts/ad/TSPITR_ORCLLDG_GMCJ/onlinelog/o1_mf_3_9nsq1jsw_.log deleted
[oracle@localhost ad]$ ls
TSPITR_ORCLLDG_GMCJ
[oracle@localhost ad]$ cd ..
[oracle@localhost tts]$ cd td/
[oracle@localhost td]$ ls
dmpfile.dmp explog.log impscrpt.sql tts.dbf
拷贝dmp文件和dbf数据文件：
[oracle@linux5 tts_test]$ scp oracle@192.168.1.223:/u01/tts/td/tts.dbf /u01/tts_test/tts.dbf
oracle@192.168.1.223's password:
tts.dbf 100% 20MB 4.0MB/s 00:05
[oracle@linux5 tts_test]$ scp oracle@192.168.1.223:/u01/tts/td/dmpfile.dmp /u01/tts_test/
oracle@192.168.1.223's password:
dmpfile.dmp 100% 68KB 68.0KB/s 00:00
导入：
SQL> select * from tab;
no rows selected
SQL> show user
USER is "TEST"
[oracle@linux5 dmp]$ impdp system/oracle dumpfile=dmpfile.dmp directory=DUMP_FILE_DIR nologfile=y transport_datafiles=/u01/tts_test/tts.dbf remap_schema=test:test
Import: Release 10.2.0.1.0 - Production on Tuesday, 15 April, 2014 1:05:34
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** dumpfile=dmpfile.dmp directory=DUMP_FILE_DIR nologfile=y transport_datafiles=/u01/tts_test/tts.dbf remap_schema=test:test
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 01:05:42
SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
TTS TABLE
检查貌似少了一张表，然后回忆以前做实验好像test默认表空间是test，后来改为了tts，传输的时候传的是默认表空间（只传输TTS）。
查看源数据库：
SQL> select table_name,tablespace_name from user_tables;
TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
TTS TTS
TEST TEST
SQL> select username,default_tablespace from user_users;
USERNAME DEFAULT_TABLESPACE
------------------------------ ------------------------------
TEST TTS
目标数据库：
SQL> select table_name,tablespace_name from user_tables;
TABLE_NAME TABLESPACE_NAME
------------------------------ -----------------------------
TTS TTS
把导入的表空间状态更改为READ WRITE