oracle中aix至Linux导出,Oracle 10gr2 从AIX 迁移到 linux CENTOS 6.4

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表空间-