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
问题解决。