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_at_gmail.com> To: <jonathan_at_jlcomp.demon.co.uk> Cc: <oracle-l_at_freelists.org> 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 Received on Wed Nov 23 2005 - 16:21:34 CST