Re: Oracle IMP Hangs

Solved!
For some reason, when the database instances were created, they did not get their "log_archive_start" parameter included in the init.ora file. When the line:
log_archive_start = true
was added to the init file and the system was restarted, imports succeeded.
Mike

"Ron" <support_at_dbainfopower.com> wrote in message news:<ltydnTsNB81-y9zdRVn-jw_at_comcast.com>...
> 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 Mon Mar 01 2004 - 17:33:29 CET