Re: sqlplus & exp "hanging" on a particular table

From: Jeremy <>
Date: Thu, 13 Oct 2011 21:24:29 +0100
Message-ID: <MPG.2901595b1a9de558989985_at_News.Individual.NET>

In article <271b03c4-55d4-432c-bbd6-86e8a95e7ae8>, says...

> Jeremy, I did a quick search of Oracle Support and did not find any
> notes that would seem to apply. I am not sure on 11.2 if the default
> is still direct=n but if so have you tried direct=y and I would add
> the buffer=1048576 (conventional) and feedback=100 parameters to see
> if feedback shows any progress for the table.
> Also check the target directory and make sure it is not near full.

OK I used the options you suggested:

. . exporting table                   X_WD_VS_VALS
EXP-00008: ORACLE error 12592 encountered
ORA-12592: TNS:bad packet
EXP-00056: ORACLE error 1403 encountered
ORA-01403: no data found
EXP-00000: Export terminated unsuccessfully

This is NOT what I referred to as PROBLEM_TABLE.

I think we have a network/firewall issue here...

PROBLEM_TABLE now exports successfully using the direct=yes but removing that option results in "hanging" again - i.e. just doesn't complete.

Very very odd. Talking with the service providers about their networks.

Received on Thu Oct 13 2011 - 15:24:29 CDT

Original text of this message