2009-06-03

exp-00002 error in writing to export file

exp导出文件到4gb时出错

在windows2000环境下,使用exp导出,当导出文件达到4gb出现
exp-00002错误

Cause: Export could not write to the export file, probably because of a device error.
This message is usually followed by a device message from the operating system.

Action: Take appropriate action to restore the device.

是因为我的操作系统磁盘分区格式为FAT32,FAT32最大的文件是4GB。

加个参数filesize,在file中指定道出的文件名1.dmp,2.dmp...
如:EXP  USER/PASS  FILES=(A.DMP,B.DMP)  FILESIZE=1500M
问题解决。