RE: Full IMP hangs at the same spot

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Fri, 07 Sep 2001 11:05:38 -0700
Message-ID: <F001.00386F90.20010907110801@fatcity.com>

Any
triggers?
 
 
"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence <FONT

face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" 
size=2>Fax:    (707) 885-2275 

Fuelspot <FONT

face="Comic Sans MS" size=2>73 Princeton Street <FONT 
face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT 
face="Comic Sans MS" size=2>  

  

<FONT

  face=Tahoma size=2>-----Original Message-----From: Thomas Jeff   [mailto:ThomasJe_at_tce.com] Sent: Friday, September 07, 2001 11:46   AMTo: Multiple recipients of list ORACLE-LSubject: Full   IMP hangs at the same spot
  We're running 8.1.7 on RS6000, AIX
  4.3.3.     We are trying to do a <FONT   face="Courier New" size=2>full exp/imp into a clone database.   The   imp hangs at the same location <FONT face="Courier New"   size=2>every time, on a table that has only 2 rows in it, although the table   does have 2 VARCHAR2(2000)
  columns.   We're unable to locate any error messages   in the available alerts, logs,
  traces, whatever.    For whatever reason, <FONT   face="Courier New" size=2>the process just goes suddenly wild on CPU cycles   and hangs there.
  Any ideas?
<FONT face="Courier New"

  size=2>-------------------------------------------- <FONT 

  face="Courier New" size=2>Jeffery D Thomas <FONT face="Courier New"   size=2>DBA Thomson Information
  Services Thomson multimedia
  Inc.
  Email: thomasje_at_tce.com <FONT
  face="Courier New" size=2>DBA Quickplace: <A target=_blank   href="http://gkmqp.tce.com/tis_dba">http://gkmqp.tce.com/tis_dba
<FONT face="Courier New"

  size=2>-------------------------------------------- 

Received on Fri Sep 07 2001 - 13:05:38 CDT