Re: RE: Export Hanging

From: Mandar Shete <mandar_shete_at_indiatimes.com>
Date: Mon, 22 Oct 2001 07:44:54 -0700
Message-ID: <F001.003B14E2.20011022080100@fatcity.com>

You're right Lisa, forgot to mention that. But we do have more than enough disk space available. Everything else seems to be ok as well with the OS - logged in as administrator, so no privilege issues either.

Mandar.

"Koivu, Lisa" wrote:

Mandar, did you have enough disk available for the export file? You don't say anything about checking your filesystem.

Lisa Koivu
Oracle Database Monkey
Fairfield Resorts, Inc.
954-935-4117

-----Original Message-----
Sent: Monday, October 22, 2001 9:50 AM To: Multiple recipients of list ORACLE-L

--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705 Content-Type: text/plain; charset=us-ascii

Hi All,

Oracle 8.1.6.1 NT 4 SP5

I'm facing a problem with all exports hanging on our production database. Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try

SID       EVENT                                  TOTAL_WAITS  TOTAL_TIMEOUTS 
63         latch free                                2                      2 
63         db file sequential read             8                   0 
63         db file scattered read               a95                 0 
63         file open                                 3                      0 
63         SQL*Net message to client      $4859             0  
63         SQL*Net more data to client    9282              0  
63         SQL*Net message from client  $4858              0

I'm running this on the server itself, so the network's not an issue. Tried different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously since we don't take regular exports.

I'm about to raise a TAR on this one, but any pointers before that would be useful.

TIA, Mandar.

Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in

--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705 Content-Type: text/html; charset=us-ascii

 Hi All,
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT:
5px">
Oracle 8.1.6.1 NT 4 SP5
I'm facing a problem with all exports hanging on our production database.
Tried it several times, but the export seems to get stuck at different points each time. The strange part is that at this point v$session_event shows absolutely nothing happening - all the wait numbers just freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be doing nothing at all. This is the output from v$session_event for my latest try

SID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
EVENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TOTAL_WAITS&nbsp;
TOTAL_TIMEOUTS 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; latch
free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&! !
!
amp;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db file sequential
read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb!

!
!
sp;db file scattered
read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

a95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0

 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
file
open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 63&a!
!
!
mp;nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net message to client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4859&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0&nbsp;

 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
SQL*Net more data to client&nbsp;&nbsp;&nbsp; 9282&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp!

!
!
;&nbsp;0&nbsp;
 63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SQL*Net
message from
client&nbsp;&nbsp;244858&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0

I'm running this on the server itself, so the network's not an issue. Tried
different export modes and parameters (full, owner, tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that this problem's been there for some time now but was never really taken seriously&nbsp;since we don't take regular exports.

I'm about to raise a TAR on this one, but any pointers before that would be
useful.
TIA,
Mandar.
&nbsp;
&nbsp;</BLOCKQUOTE>
<hr>Get Your Private, Free E-mail
from Indiatimes at <a href="http://email.indiatimes.com">http://email.indiatimes.com</a> Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from <A href="http://www.planetm.co.in">http://www.planetm.co.in</A>

--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Mandar Shete 
  INET: mandar_shete_at_indiatimes.com 


Fat City Network Services    -- (858) 538-5051  FAX: (858) S8-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
-------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 
Get Your Private, Free E-mail from Indiatimes at  http://email.indiatimes.com
Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from 
http://www.planetm.co.in

--=_MAILER_ATTACH_BOUNDARY1_2001102212023232124898138
Content-Type: text/html; charset=us-ascii

<P>You're right Lisa, forgot to mention that. But we do have more than enough disk 
space available. Everything else seems to be ok as well with the OS - logged in as 
administrator, so no privilege issues either.</P>
<P>Mandar.</P>
<P><BR><BR><B><I>"Koivu, Lisa"<LISA.KOIVU_at_EFAIRFIELD.COM></B></I> wrote: <BR></P>
<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 
5px"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<META content="MS Exchange Server version 5.5.2653.12" name=Generator>
<P><FONT color=#0000ff face=Georgia>Mandar, did you have enough disk available for the 
export file?&nbsp; You don't say anything about checking your filesystem.</FONT> </P>
<P><FONT face=Georgia>Lisa Koivu</FONT> <BR><FONT face=Georgia>Oracle Database 
Monkey</FONT> <BR><FONT face=Georgia>Fairfield Resorts, Inc.</FONT> <BR><FONT 
face=Georgia>954-935-4117</FONT> </P><BR>
<UL>
<P><FONT face=Arial size=1>-----Original Message-----</FONT> <BR><B><FONT face=Arial 
size=1>From:&nbsp;&nbsp;</FONT></B> <FONT face=Arial size=1>Mandar Shete 
[SMTP:mandar_shete_at_indiatimes.com]</FONT> <BR><B><FONT face=Arial 
size=1>Sent:&nbsp;&nbsp;</FONT></B> <FONT face=Arial size=1>Monday, October 22, 2001 
9:50 AM</FONT> <BR><B><FONT size=1 úCE="Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> 
<FONT size=1 úCE="Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT 
size=1 úCE="Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT 
face=Arial size=1>Export Hanging</FONT> </P>
<P><FONT size=2 
úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705</FONT> <BR><FONT 
face=Arial size=2>Content-Type: text/plain; charset=us-ascii</FONT> </P><BR>
<P><FONT face=Arial size=2>Hi All,</FONT> </P><BR><BR>
<P><FONT face=Arial size=2>Oracle 8.1.6.1 NT 4 SP5</FONT> </P><BR>
<P><FONT face=Arial size=2>I'm facing a problem with all exports hanging on our 
production database. Tried it several times, but the export seems to get stuck at 
different points each time. The strange part is that at this point v$session_event 
shows absolutely nothing happening - all the wait numbers just freeze indefinitely and 
v$session_wait shows a 'SQL*Net message from client' wait - the session seems to be 
doing nothing at all. This is the output from v$session_event for my latest 
try</FONT></P><BR>
<P><FONT size=2 úCE="Arial">SID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
EVENT&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 TOTAL_WAITS&nbsp; TOTAL_TIMEOUTS</FONT> <BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; latch 
free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 2</FONT> <BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db file sequential 
read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb!
!
!
sp;&nbsp;&nbsp;&nbsp; 0</FONT> <BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; db file scattered 
read&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
a95&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 0 </FONT><BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; file 
open&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 
3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
 0</FONT> <BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net message to 
client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
$4859&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp; 
</FONT><BR><FONT size=2!
!
!
 úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net more data to 
client&nbsp;&nbsp;&nbsp; 
9282&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
0&nbsp; </FONT><BR><FONT size=2 
úCE="Arial">63&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SQL*Net message from 
client&nbsp; 
$4858&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
0</FONT> </P><BR><BR>
<P><FONT face=Arial size=2>I'm running this on the server itself, so the network's not 
an issue. Tried different export modes and parameters (full, owner, tables, buffer, 
direct, etc.) but with the same result. I'm pretty new to this site, but I'm told that 
this problem's been there for some time now but was never really taken seriously since 
we don't take regular exports.</FONT></P><BR>
<P><FONT face=Arial size=2>I'm about to raise a TAR on this one, but any pointers 
before that would be useful.</FONT> </P><BR>
<P><FONT face=Arial size=2>TIA,</FONT> </P><BR>
<P><FONT face=Arial size=2>Mandar.</FONT> </P><BR>
<P><FONT face=Arial size=2>&nbsp;</FONT> </P><BR>
<P><FONT face=Arial size=2>&nbsp;</FONT> <BR><FONT face=Arial size=2>Get Your Private, 
Free E-mail from Indiatimes at&nbsp; <A href="http://email.indiatimes.com/" 
target=_blank>http://email.indiatimes.com</A></FONT> <BR><FONT face=Arial size=2>Buy 
Music, Video, CD-ROM, Audio-Books and Music Accessories from <A 
href="http://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A></FONT> </P>
<P><FONT size=2 
úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705</FONT> <BR><FONT 
face=Arial size=2>Content-Type: text/html; charset=us-ascii</FONT> </P>
<P><FONT face=Arial size=2>&lt;BR&gt;&lt;BR&gt;Hi All,</FONT> <BR><FONT face=Arial 
size=2>&lt;BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; 
PADDING-LEFT: 5px"&gt;</FONT> <BR><FONT face=Arial size=2>&lt;P&gt;Oracle 8.1.6.1 NT 4 
SP5&lt;/P&gt;</FONT> <BR><FONT face=Arial size=2>&lt;P&gt;I'm facing a problem with 
all exports hanging on our production database. Tried it several times, but the export 
seems to get stuck at different points each time. The strange part is that at this 
point v$session_event shows absolutely nothing happening - all the wait numbers just 
freeze indefinitely and v$session_wait shows a 'SQL*Net message from client' wait - 
the session seems to be doing nothing at all. This is the output from v$session_event 
for my latest try&lt;/P&gt;</FONT></P>
<P><FONT size=2 
úCE="Arial">&lt;P&gt;SID&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
EVENT&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 TOTAL_WAITS&amp;nbsp; 
TOTAL_TIMEOUTS&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 latch 
free&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 
2&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&am!
!
!
p;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;2&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 db file sequential 
read&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 
8&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;0&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nb!</FONT></P>
<P><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>!</FONT> <BR><FONT 
face=Arial size=2>sp;db file scattered 
read&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 
a95&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;0
 


&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

 file 
open&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 
3&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;!
!
!
nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
0&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 SQL*Net message to client&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
$4859&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;0&amp;nbsp;
 


&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;

 SQL*Net more data to client&amp;nbsp;&amp;nbsp;&amp;nbsp; 
9282&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp!</FONT></P>
<P><FONT face=Arial size=2>!</FONT> <BR><FONT face=Arial size=2>!</FONT> <BR><FONT 
face=Arial size=2>;&amp;nbsp;0&amp;nbsp; 


&lt;BR&gt;63&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;SQL*Net

 message from 
client&amp;nbsp;&amp;nbsp;244858&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;
 0&lt;BR&gt;&lt;/P&gt;</FONT></P>
<P><FONT face=Arial size=2>&lt;P&gt;I'm running this on the server itself, so the 
network's not an issue. Tried different export modes and parameters (full, owner, 
tables, buffer, direct, etc.) but with the same result. I'm pretty new to this site, 
but I'm told that this problem's been there for some time now but was never really 
taken seriously&amp;nbsp;since we don't take regular exports.&lt;/P&gt;</FONT></P>
<P><FONT face=Arial size=2>&lt;P&gt;I'm about to raise a TAR on this one, but any 
pointers before that would be useful.&lt;/P&gt;</FONT> <BR><FONT face=Arial 
size=2>&lt;P&gt;TIA,&lt;/P&gt;</FONT> <BR><FONT face=Arial 
size=2>&lt;P&gt;Mandar.&lt;/P&gt;</FONT> <BR><FONT face=Arial 
size=2>&lt;P&gt;&amp;nbsp;&lt;/P&gt;</FONT> <BR><FONT size=2 
úCE="Arial">&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;/BLOCKQUOTE&gt;</FONT> <BR><FONT 
face=Arial size=2>&lt;hr&gt;&lt;font face="Arial" size="2"&gt;&lt;b&gt;Get Your 
Private, Free E-mail from Indiatimes at&nbsp; &lt;/font&gt;&lt;a href="<A 
href="http://email.indiatimes.com/" 
target=_blank>http://email.indiatimes.com</A>"&gt;&lt;font face="Arial" size="2"&gt;<A 
href="http://email.indiatimes.com/" 
target=_blank>http://email.indiatimes.com</A>&lt;/font&gt;&lt;/a&gt;&lt;/b&gt;&lt;br&gt;Buy
 Music, Video, CD-ROM, Audio-Books and Music Accessories from &lt;A href="<A 
href="http://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A>"&gt;<A 
href="htt!
!
!
p://www.planetm.co.in/" target=_blank>http://www.planetm.co.in</A>&lt;/A&gt;</FONT></P>
<P><FONT size=2 
úCE="Arial">--=_MAILER_ATTACH_BOUNDARY1_200110221181548701943705--</FONT> </P>
<P><FONT face=Arial size=2>-- </FONT><BR><FONT face=Arial size=2>Please see the 
official ORACLE-L FAQ: <A href="http://www.orafaq.com/" 
target=_blank>http://www.orafaq.com</A></FONT> <BR><FONT face=Arial size=2>-- 
</FONT><BR><FONT face=Arial size=2>Author: Mandar Shete</FONT> <BR><FONT face=Arial 
size=2>&nbsp; INET: mandar_shete_at_indiatimes.com</FONT> </P>
<P><FONT face=Arial size=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 
538-5051&nbsp; FAX: (858) S8-5051</FONT> <BR><FONT face=Arial size=2>San Diego, 
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access / 
Mailing Lists</FONT> <BR><FONT size=2 
úCE="Arial">--------------------------------------------------------------------</FONT>
 <BR><FONT face=Arial size=2>To REMOVE yourself from this mailing list, send an E-Mail 
message</FONT> <BR><FONT face=Arial size=2>to: ListGuru_at_fatcity.com (note EXACT 
spelling of 'ListGuru') and in</FONT> <BR><FONT face=Arial size=2>the message BODY, 
include a line containing: UNSUB ORACLE-L</FONT> <BR><FONT face=Arial size=2>(or the 
name of mailing list you want to be removed from).&nbsp; You may</FONT> <BR><FONT 
face=Arial size=2>also send the HELP command for other information (like 
subscribing).</FONT> </P></UL></BLOCKQUOTE>
<hr><font face="Arial" size="2"><b>Get Your Private, Free E-mail from Indiatimes at  
</font><a href="http://email.indiatimes.com"><font face="Arial" 
size="2">http://email.indiatimes.com</font></a></b><br>Buy Music, Video, CD-ROM, 
Audio-Books and Music Accessories from <A 
href="http://www.planetm.co.in">http://www.planetm.co.in</A>

--=_MAILER_ATTACH_BOUNDARY1_2001102212023232124898138--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mandar Shete
  INET: mandar_shete_at_indiatimes.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Oct 22 2001 - 09:44:54 CDT