Re: IMP: still more problems

From: Enkidu Utnapishtim <utnapishtim43NOSPAM_at_hotmail.com>
Date: Fri, 19 Jul 2002 21:41:35 GMT
Message-ID: <3D38878E.9080309@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

Sybrand Bakker wrote:

> On Fri, 19 Jul 2002 11:34:57 -0400, "Chuck" <chuckh_at_softhome.net>
> wrote:
> 
> 

>>I am encountering even *more* problems with the 8.1.7 import utility on AIX.
>>Am I doing something wrong or is this utility just a piece of cr*p?
>>
>>Latest issue. I am trying to use a norows full export to create indexes,
>>primary keys, constraints, grants etc. on a database that I copied from
>>another platform using CTAS on every table. (I used CTAS to load the data
>>because import was too slow. It took 70+ hours whereas CTAS took about 3.)
>>The create index and alter statements are in the export file to create the
>>unique indexes for the PKs, then alter them to PK constraints. I can grep
>>them out of the file with no problem. The import however never even tries to
>>apply them. There are no errors in the log file indicating that it failed to
>>apply them for any reason. It just ignores them. It also ignores all of my
>>FK constraints.
>>
>>Before I open a tar with oracle, is this expected behavior for EXP/IMP? Am I
>>forgetting something?
>>
>>Here is the command I am using to run the export and the import. The last
>>line of the export log file says it finished with no warnings.
>>
>>exp user/pass file=norows full=y rows=n log=norows_export.log
>>imp user/pass file=norows full=y log=norows_import.log
>>
>>

> 
> 

>>I am encountering even *more* problems with the 8.1.7 import utility on AIX.
>>Am I doing something wrong or is this utility just a piece of cr*p?

> 
> 
> Millions of people can use it.
> 
> 
> 

>>Here is the command I am using to run the export and the import. The last
>>line of the export log file says it finished with no warnings.
>>
>>exp user/pass file=norows full=y rows=n log=norows_export.log
>>imp user/pass file=norows full=y log=norows_import.log

> 
> 
> Doesn't tell much does it?  And crystall balls have sold out here.
> 
> Regards
> 
> 
> Sybrand Bakker, Senior Oracle DBA
> 
> To reply remove -verwijderdit from my e-mail address

Received on Fri Jul 19 2002 - 16:41:35 CDT