Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: IMP: still more problems
Thanks for the reply. At least I don't feel that I'm out in left field by
myself on this. Ego trips are mostly all I get from Sybrand. As of today
he's in my killfile.
BTW your first name is very unique. It wouldn't have anything to do with the Egyptian legend would it?
-- Chuck "Enkidu Utnapishtim" <utnapishtim43NOSPAM_at_hotmail.com> wrote in message news:3D38878E.9080309_at_hotmail.com...Received on Sat Jul 20 2002 - 02:11:40 CDT
> Chuck,
> Disregarding Sybrand's ego trip (it's a lot easier to make non-helpful
> statements like "millions of people use it" than to answer a question),
> you are right. Both exp/imp have problems. Perhaps those millions of
> people who have used exp/imp have not tried to load views that are based
> on Java functions (if the jvm can't "compile" the java function before
> it gets to the "create view" portion of the .dmp file, it will give you
> a IMP-00041 error). There are other problems as well because imp is a
> strictly sequential thing ... and if the database asynchronously ships a
> task off to a background job that doesn't get finished in time, then imp
> will fail. Don't know if your problem is related to this imp-blindness
> or not. I'd submit that tar if I were you.
>
> I've run into problems with imp often enough that I sometimes prefer to
> build dynamic sql scripts on the source machine that I ftp over to the
> target machine and run them manually. It's often much more reliable than
> imp ... especially in those cases where imp fails due to timing
> difficulties.
>
> HTH,
> Roger Crowley - DBA - LearningFramework