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

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

In article <271b03c4-55d4-432c-bbd6-86e8a95e7ae8 _at_x6g2000prn.googlegroups.com>, Mark.Powell2_at_hp.com 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.

-- 
jeremy

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