数据泵的限制因素

众所周知，数据泵与常规导入导出不同，使用的是本地而不是远程资源进行作业，所有数据泵只能在本地工作
数据泵还需要检查磁盘空间，创建目录、授权，版本考虑（上一章已讲述），业务是否受影响等等因素。
除了上述一些刚开始使用数据泵应该考虑的因素外，还有一些比较容易忽略的因素

1.因为不能创建master表，所以源库不能是read-only
2.数据泵不支持current user dblink
3.network_link参数不支持long型。会报ora-31679错误
4.network_link参数不支持包含对象类型的表。会报ora-22804错误
5.network_link和tables参数一起使用时，只能导出分区表的全表，而不只是指定分区。
6.当使用数据泵full模式时，建议源库和目标数据库及时安装补丁集
- for Oracle 7.3.2 source database: have the 7.3.2.3.0 patchset installed; 
- for Oracle 7.3.3 source database: have the 7.3.3.6.0 patchset installed; 
- for Oracle 7.3.4 source database: have the 7.3.4.5.0 patchset installed; 
- for Oracle 8.0.3 source database: have the 8.0.3.2.0 patchset installed; 
- for Oracle 8.0.4 source database: have the 8.0.4.4.0 patchset installed; 
- for Oracle 8.0.5 source database: have the 8.0.5.2.1 patchset installed; 
- for Oracle 8.0.6 source database: have the 8.0.6.3.0 patchset installed (see: Patch:1645513); 
- for Oracle8i Release 1 source database: have the 8.1.5.1.0 patchset installed; 
- for Oracle8i Release 2 source database: have the 8.1.6.3.0 patchset installed (see: Patch:1650087) or if withdrawn, the 8.1.6.3.1 or 8.1.6.3.2 patchset; 
- for Oracle8i Release 3 source or target database: have the 8.1.7.4.0 patchset installed (see: Patch:2376472); 
- for Oracle9i Release 1 source database: have the 9.0.1.4.0 patchset installed (see: Patch:2517300) or the 9.0.1.5.0 patchset for iAS infrastructure configurations (see: Patch:3301544); 
- for Oracle9i Release 2 source or target database: have the 9.2.0.8.0 patchset installed (see: Patch:4547809);
- for Oracle10g Release 1 source or target database: have the 10.1.0.5.0 patchset installed (see: Patch:4505133); 
- for Oracle10g Release 2 source or target database: have the 10.2.0.5.0 patchset installed (see: Patch:8202632);
- for Oracle11g Release 1 target database: have the 11.1.0.7.0 patchset installed (see: Patch:6890831);
- for Oracle11g Release 2 target database: have the 11.2.0.4.0 patchset installed (see: Patch:13390677);
- for Oracle12c Release 1 target database: have the 12.1.0.2.0 patchset installed (see: Patch:21419221);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31461640/viewspace-2142167/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31461640/viewspace-2142167/