Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: IMP: still more problems

Re: IMP: still more problems

From: Chuck <chuckh_at_softhome.net>
Date: Sat, 20 Jul 2002 03:11:40 -0400
Message-ID: <ahb2fd$s2uoi$1@ID-85580.news.dfncis.de>


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...

> 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
Received on Sat Jul 20 2002 - 02:11:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US