使用exp报错，请大家看看

zmvb

我刚才使用exp导一张表出来，报如下错误：

Export: Release 8.1.7.4.0 - Production on Thu Oct 27 23:22:41 2005

(c) Copyright 2000 Oracle Corporation.  All rights reserved.


Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
With the Partitioning and Parallel Server options
JServer Release 8.1.7.4.0 - 64bit Production
Export done in ZHS16GBK character set and ZHS16GBK NCHAR character set
Note: indexes on tables will not be exported
About to export specified tables via Conventional Path ...
. . exporting table                      ACCT_ITEM
. . exporting partition                         PART_1
.................................................................kgefec: fatal error 0
********** Internal heap ERROR 17113 addr=0x0 *********


******************************************************
HEAP DUMP heap name=""  desc=0x0
extent sz=0x0 alt=0 het=0 rec=0 flg=0 opc=0
parent=0 owner=0 nex=0 xsz=0x0
Hla: 0

**** Recursive heap error: 17113 addr=0x0, ds=0
Segmentation fault(coredump)
exp的语句我以前用过很多次了，也没问题，exp_acct.par的语句如下：
file=(20050217_acct_item_1.dmp, 20050217_acct_item_2.dmp, 20050217_acct_item_3.dmp, 20050217_acct_it
em_4.dmp, 20050217_acct_item_5.dmp, 20050217_acct_item_6.dmp, 20050217_acct_item_7.dmp, 20050217_acc
t_item_8.dmp, 20050217_acct_item_9.dmp, 20050217_acct_item_10.dmp, 20050217_acct_item_11.dmp, 200502
17_acct_item_12.dmp, 20050217_acct_item_13.dmp, 20050217_acct_item_14.dmp, 20050217_acct_item_15.dmp
, 20050217_acct_item_16.dmp, 20050217_acct_item_17.dmp, 20050217_acct_item_18.dmp, 20050217_acct_ite
m_19.dmp, 20050217_acct_item_20.dmp) filesize=1500MB tables=acct_item buffer=10240 INDEXES=N  feedba
ck=100000 log=ACCT_ITEM_20050217.log
为什么会报以上错误，请指教，谢谢！

zmvb

我把acct_item表中的数据备出来，然后truncate掉acct_item表（没从建该表），然后再把数据导回去，再用exp，还是报这个错

zmvb

有知道原因的吗？

txfy

The error indicates that during the export, data was written out of the buffer.
Some factors which can affect include the size of the rows (really large rows
would make this more likely), whether the export is local/remote, the load on
the system, etc.  When the buffer filled, and was being written to disk as a
unit, there was insufficient I/O to perform the operation before the buffer
overflowed. The buffer, once filled, is not written out and reduced
incrementally, it gets dumped as an array, and is not cleared until this is
done. Reducing the buffer size puts less stress on the system to get that
array written before the buffer is exceeded.

如果用远程连接备份，改成本地看看，另外减小buffer看看！