Dump file set for wxlun.SYS_EXPORT_TABLE_01 is:
? /u01/app/oracle/expdp/wxlun1212.dmp
Job "wxlun"."SYS_EXPORT_TABLE_01" successfully completed at Fri Dec 12 08:09:02 2014 elapsed 0 00:00:05
再次导入,成功:
[oracle@orcle02 ~]$ impdp? scott/tiger? directory=expdp? dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott? REMAP_TABLESPACE=wxlun:USERS
Import: Release 10.2.0.4.0 - 64bit Production on Friday, 12 December, 2014 8:09:36
Copyright (c) 2003, 2007, Oracle.? All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SCOTT"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SCOTT"."SYS_IMPORT_FULL_01":? scott/******** directory=expdp dumpfile=wxlun1212.dmp logfile=wxlun1212.log remap_schema=wxlun:scott REMAP_TABLESPACE=wxlun:USERS
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "SCOTT"."WXLUN_TAB01"? ? ? ? ? ? ? ? ? ? ? 19.41 MB? 169682 rows
. . imported "SCOTT"."WXLUN_TAB02"? ? ? ? ? ? 18.43 MB? 168011 rows
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "SCOTT"."SYS_IMPORT_FULL_01" successfully completed at 08:10:54
[oracle@orcle02 ~]$