文档解释
ORA-39059: 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.
ORA-39059: dump文件集不完整
官方解释
ORA-39059:导出失败:导出文件集不完整。操作可能失败。
常见案例
ORA-39059错误通常是由于目标文件系统空间不足导致的,通常是由文件的容量不足引起的,这将导致导出操作失败。
一般处理方法及步骤
1.首先删除多余的无用文件,释放空间;
2.增加文件系统的容量,以便导出操作正常;
3.如果导出出现问题,可以将表或者其它对象拆分成多个单独的对象,将它们分别导出;
4.在导出操作中使用参数COMPRESS,SKIP_CONSTRAINT_ERROR,大大减少了操作失败的可能性;
5.避免使用不安全的操作系统账号进行导出操作,以避免权限不足导致的错误。