Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01": /********/ AS SYSDBA directory=backup dumpfile=test01.dmp transport_datafiles=/u01/app/oracle/oradata/normal/test01.dbf remap_schema=source_test:target_test logfile=test.log
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at 17:09:55
9、查看并修改表空间状态
select tablespace_name,
status
from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMPTS1 ONLINE
USERS ONLINE
OUTLN ONLINE
TSET READ ONLY
7 rows selected.
SQL> alter tablespace TSET read write;
Tablespace altered.
10、验证
SQL> conn target_test/oracle
Connected.
SQL> select * from t1;
1.
ID NAME
---------- ------------------------------
1 AAAAA
2 BBBBB
总结：
（一）：如果是跨平台了，则需要进行平台转换，可以在源端操作也可以在目的端操作。
例如：
源端：
SQL>SELECTd.PLATFORM_NAME,ENDIAN_FORMATFROMV$TRANSPORTABLE_PLATFORM tp,V$DATABASE dWHEREtp.PLATFORM_NAME=d.PLATFORM_NAME;
SQL>PLATFORM_NAME ENDIAN_FORMAT
----------------------------- --------------
Linux x8664-bit Little
目标端：
SQL>SELECTd.PLATFORM_NAME,ENDIAN_FORMATFROMV$TRANSPORTABLE_PLATFORM tp,V$DATABASEdWHEREtp.PLATFORM_NAME=d.PLATFORM_NAME;