Re: Imp troubles

Did you try running the imp from the command line? How big is the dump file? What os, db version? If unix/solaris, what does top show?
Does the import work with a much smaller export dump?

I have seen imp to be slow for various reasons (dump file on slow NFS was one of them)
.. but never seen it stuck...

Anurag

"Luke Scharf" <luke_at_vt.edu> wrote in message news:afv0v3$5gm$1_at_solaris.cc.vt.edu...
> I've managed to install Oracle server, and get the OEM running. I've
> also managed to get the backup/restore wizards to run to completion on my
> exp'd data.
>
> The problem is that when I run imp (or the OEM import wizard), imp will
chew on
> my dump file for about an hour and report no error messages - but I can't
find
> where any tables were created or users/schemas added.
>
> Can anyone get me started on solving this problem?
> Any ideas about what's happening?
> What would you look for?
>
> Thanks in advance!
> -Luke
Received on Wed Jul 03 2002 - 09:32:29 CDT