1.aix  expdp 导出

2.ftp 传输  ,注意要使用bin模式传输否则会导致以下报错,还有要注意的就是directory 权限read,write

Import: Release 10.2.0.5.0 - 64bit Production on Friday, 22 November, 2013 16:01:28

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31694: master table "SYSTEM"."SYS_IMPORT_FULL_01" failed to load/unload
ORA-31640: unable to open dump file "/ncsoft/2013_11_22.dmp" for read
ORA-19505: failed to identify file "/ncsoft/2013_11_22.dmp"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1
ORA-39014: One or more workers have prematurely exited.

3. impdp导入    由于源库和目标库  结构不一样  ,源库有temp2临时表空间的,导出的用户也是默认这个表空间,还有导出的用户的表放在多个表空间了,我就通过remap_tablespaces 参数都放到users表空间-

10-10 00:47