Re: hanged on import on undo segment


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
--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l


Other related posts: