hanged on import on undo segment

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 23 Nov 2005 13:39:25 -0400
Message-ID: <cd4305c10511230939o370fd6edn98517f76f7b6c413@mail.gmail.com>

Hi, please
What can I do to solve this situation.
I get an import hanged on an undo segment. Thank you
SQL> select row_wait_file#,row_wait_block# from v$session where not row_wait_block#=0;
ROW_WAIT_FILE# ROW_WAIT_BLOCK#
-------------- ---------------

             2 137
SQL> SELECT SEGMENT_TYPE "Tipo", SEGMENT_NAME "Segmento",   2 (SELECT D.NAME FROM V$DATAFILE D WHERE D.FILE#= FILE_ID) "DataFile", BLOCK_ ID "Bloque", FILE_ID "Datafile No."
  3 FROM DBA_EXTENTS
  4 WHERE FILE_ID=2
  5 AND 137 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS;

Tipo               Segmento
TYPE2 UNDO         _SYSSMU8$

--

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

8 years of experience in Oracle 7,8i,9i,10g and developer 6i
--

http://www.freelists.org/webpage/oracle-l Received on Wed Nov 23 2005 - 11:43:18 CST