BEWARE OF 8.0.5 exp/imp - was HELP: import 'hangs'

I have some information I would like to share with you.

It is starting to look like there is a 'problem' with the .dmp file. FYI, here is what I have found.

I have copied the .dmp file to 3 different machines...

    Solaris #1 (where the .dmp was created)     Solaris #2
    NT #1

Both of the Solaris machines are on Solaris 2.6 and had Oracle 8.0.5 installed from this same CD. The NT box is also 8.0.5

I tried to run imp with rows=n i.e. list the file only. Guess what... imp get stuck on the same table that it can't completely load. However, the place where it gets stuck is different on the two Solaris machines!!! I can consistantly get imp to 'spin it's wheels' at the same spots but only on the two different machines. i.e. Solaris #1 always get stuck on the 5th table of the .dmp and Solaris #2 always gets stuck on the 7th table of the .dmp file!!!

When I try to import the .dmp file on the NT machine with rows=n, it reads to the 7th table in the file, sits there for about 5 minutes, and comes back with the 'IMP-00009: abnormal end of export' message.

Bottom line is the exp created a 'bad' .dmp file but gave no errors, but I can't explain why imp gets 'stuck' at different spots when run on different machines with the same rev of Oracle

You have been warned. Don't trust exp/imp

Ron Bogdanoff

 article <7c8paa$66k$1_at_nnrp1.dejanews.com>,   ronb_at_digitalmarket.com wrote:
> Hi,
>
> Has anyone seen this problem?
>
> I am on Oracle8.0.5 on Solaris 2.6
>
> I have a .dmp file that is about 1.5gb. Some of the tables in the file have >
> 1,000,000 rows.
>
> When I try to import, the import works as normal, but when it gets to the
> first large table, it imports about 300,000 of the 1,000,000+ rows and then
> 'hangs'.
>
> What I mean by 'hang' is that the imp process uses cpu cycles, but the Oracle
> background process are not doing anything. No more log switched happen at
> this point. It will sit there forever until I do a shutdown abort. If I try
> running the import again, it hangs at the same spot. I have indexes=n
> commit=y on the imp.
>
> I have ported the .dmp file to another Solaris box running Oracle8.0.5 also,
> and it get past the point in the import where it has been 'hanging', but
> further 'down the road' in the import it does hang.
>
> Has anyone seen this before?
>
> Thank You
>
> Ron Bogdanoff
> Sr. Software Engineer
> DigitalMarket Inc.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Mar 11 1999 - 15:00:53 CST