Re: Error ORA-02715 during database export
Date: 1997/07/07
Message-ID: <5pretv$99i_at_atglab10.atglab.bls.com>#1/1
Arthur <arthurw_at_hkstar.com> wrote:
>Our company is running Oracle 7.1.4 on Unisys U6000/580 (dual
>Pentium-120) Unix SVR4 ver 1.4. Recently we added an RAID disk to the
>machine and since then when we performed an Oracle export, we will
>encounter an ORA-02715 error (pipe driver receives an incorrect message
>type from Unix) and aborted.
>We experienced different buffer size (from 4096 to 100000) and we found
>that the larger the buffer size, the earlier we will encounter the
>error. Any idea?
>Arthur
>arthurw_at_hkstar.com
Arthur,
You encounter the error earlier with the larger buffer size because you have improved the performance of the export!
I'd give it one more shot with :
buffer=<big number like 10000000>
to rule out the failure being caused by a very long row(s). If the
export STILL fails then look for other associated error messages and
post them here or call Oracle support (oof, save that for last unless
you've got plenty of time to hold on the phone!)
Hope this helps.
Mary
Mary Travis
BellSouth Telecommunications
email: Mary.B.Travis_at_bridge.bellsouth.com
Received on Mon Jul 07 1997 - 00:00:00 CEST