Re: Error ORA-02715 during database export

From: Mary Travis <Mary.B.Travis_at_bridge.bellsouth.com>
Date: 1997/07/07
Message-ID: <5pretv$99i@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 CDT