EXP-00002 EXP-00000 compress压缩比惊人

exp报错如下：

EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table                  SEC_OP_AUTHOR
EXP-00002: error in writing to export file
EXP-00002: error in writing to export file
EXP-00000: Export terminated unsuccessfully

不仅报错，而且连dmp文件都没有生成。

 

文件系统剩余情况

/dev/mapper/vg_rhel6-nzdmp
                       20G   12G  6.9G  64% /nzdmp

还剩6g，对象大小也是6g。

 

ulimit限制：

core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited

file都是unlimit

 

单独导出该表

. . exporting table                  SEC_OP_AUTHOR   18968947 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

成功导出，查看大小居然有2g

-rw-r--r--. 1 oracle oinstall 2268471296 Nov 12 14:44 sec_op_author.dmp

在源库中查看查下该表的大小

OWNER                                  GB
------------------------------ ----------
lzl                     1.15429688

原表只有1.1g，exp导出加压缩居然有2.2g

可以判断第一次exp也是因为文件太大了。但是对象只有那么大，而且还加了compress

exp真的有点low