Re: Oracle IMP Hangs
From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 27 Feb 2004 10:26:56 -0500
Message-ID: <tKmdneaQf4Vf_KLd4p2dnA_at_comcast.com>
Date: Fri, 27 Feb 2004 10:26:56 -0500
Message-ID: <tKmdneaQf4Vf_KLd4p2dnA_at_comcast.com>
"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
check the alert log for error messages
make sure there are no locks on the tables being imported
;-{ mcs Received on Fri Feb 27 2004 - 16:26:56 CET