Re: Oracle IMP Hangs

Hello Mike,

   Are you sure it hangs? As a start point - check alert log messages and check what top oracle user processes are doing .

   Also, you can use imp parameter FEEDBACK=<n_rows> to see if import is progressing.

   Please, let us know if more help is needed.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Mike Morris" <morrisma_at_ei.dupont.com> wrote in message news:3b2c6993.0402270719.258ac282_at_posting.google.com...
> I am exporting from one 8.1.7.4 solaris 8 box and importing on another
> similarly configured (but more capable) solaris box. The import starts
> fine but hangs after a varying number of tables are imported.
>
> The command I use:
> imp name/pwd_at_instance full=y file=xxx.dmp
>
> I have the /etc/system set as required for oracle.
> I have used this technique dozens of times and never had this happen.
> Any suggestions would be appreciated!
> Mike Morris
Received on Sun Feb 29 2004 - 04:12:05 CET