分类： LINUX
2013-11-22 17:25:11
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表空间-
