Re: Import

From: Andreas Stephan <nospam.as.stedat_at_gmx.net>
Date: 2000/05/12
Message-ID: <391BC010.3B9D5EB3_at_gmx.net>#1/1


The error message hints to a problem in the os call to open the file. Have you tried to mv your file to another name and/or to cat or more the file (at least the first lines)?

Andy

Raymond van Daelen schrieb:

> Thanks for the suggestion, but itis not likely the cause. I run export as
> user oracle and the dmp files are owned by oracle.
>
> Raymond
>
> Andreas Stephan wrote:
>
> > Possibly you have the wrong rights. Look at the access rights and
> > owner/group of the file.
> > Try a chown user:group expdat.dmp where user is your actual user and
> > group is your default group.
> >
> > Hope this helps.
> > Andy
> >
> > Raymond van Daelen schrieb:
> >
> > > Hello there,
> > >
> > > I am experiencing some problems with Imprting an export dump file into
> > > my Oracle8 database running on redhat linux 6. The exprot was made from
> > > a Oracle 8 databse running on Sun Solaris.
> > >
> > > I have made the appropriate tablespaces and users whom the objects will
> > > belong to. but starting up imp I get an error message that the dumpfile
> > > cannot be read:
> > > IMP-00002: failed to open expdat.dmp for read
> > > IMP-00021: operating system error - error code (dec2, hex 0x2)
> > > The same dump files were used by other people and there the could be
> > > used just fine, so I assume that they are not corrupt. The explanation
> > > with IMP-00021 was notto helpful,well at least I coulds not find any
> > > documentation that could help me"
> > >
> > > Does anyone have a clue as to what I can do to alieviate the problem?
> > >
> > > Many thanks
> > >
> > > Regards Raymond
Received on Fri May 12 2000 - 00:00:00 CEST

Original text of this message