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
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