Thanks to everyone, now I am less stupid than yesterday :) I changed open_links = 10 and COMPILE=N, and the process run OK. It seem to be too few open_links and instead of giving an error, it simply hanged. On 11/23/05, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> wrote: > > 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 > > > > -- Oracle Certified Profesional 9i 10g Orace Certified Professional Developer 6i 8 years of experience in Oracle 7,8i,9i,10g and developer 6i -- //www.freelists.org/webpage/oracle-l