1,
Error: ORA-39059 (ORA-39059)
Text: dump file set is incomplete
---------------------------------------------------------------------------
Cause: An IMPORT or SQL_FILE operation was being performed but not all
of the files from the EXPORT dump file set were included.
Action: Check the export log file and make sure all of the files that
were exported are included in the current job.
expdp出多个文件(不管是否并行),那么最好使用impdp导入所有的文件,因为很可能单个文件不能包含某个表的全部数据
2,
报错只有ORA-31693和ORA-29913组合出现
如果是由于使用并行参数导致的,那么注意:
导出的时候用parallel,然后导入的时候也用parallel
3,
使用并行导出单个大表到单个文件,并不能比不使用并行有多少的提升,不过导出到多个文件,且文件数量和并行度设置的适宜则大大提高速度,
并行度根据系统cpu数量和当前负载来决定,一般为cpu个数70%
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16179598/viewspace-743799/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16179598/viewspace-743799/