Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Full IMP hangs at the same spot

RE: Full IMP hangs at the same spot

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 07 Sep 2001 09:21:49 -0700
Message-ID: <F001.00386CB5.20010907090532@fatcity.com>

truss,
strace whatever.
<FONT face=Arial color=#0000ff

size=2> 
<FONT face=Arial color=#0000ff

size=2>v$session_wait
<FONT face=Arial color=#0000ff

size=2> 
the
usual....

  <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 - 11:21:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US