Re: hanged on import on undo segment
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: <juancarlosreyesp@xxxxxxxxx>
- Date: Wed, 23 Nov 2005 22:19:17 -0000
Since it's a system that I can't take a look at,
I am not keen about giving advice like killing
processes - but from the session_wait we've
got, it looks like the import will never get a
message to continue. In your position, I think
I'd kill it, clean up, and start again.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 4th Nov 2005
----- Original Message -----
From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
To: <jonathan@xxxxxxxxxxxxxxxxxx>
Cc: <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, November 23, 2005 8:32 PM
Subject: Re: hanged on import on undo segment
Jonathan I dropped database links so links used for that procedures
have all (4 links ) avaiable connecting, I tested and all of them are
working, but import doesn't resume.?
Is there some trick to resume or to say to imp.exe, hey try again.
I remember the period of time to retry was growing logarithmically.
So what do you suggestme, kill the import , or wait to get it retryied.
Thanks
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
