Re: Exporting Unix DB to NT

"D. Oakley" wrote:
>
> Firstly, thanks for the response. Yes, binary mode was used.. the following
> is the error message given during import process:
>
> Import: Release 7.3.3.0.0 - Production on Thu Apr 22 09:53:08 1999
>
> Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
>
> Connected to: Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed, replication and parallel query options
> PL/SQL Release 2.3.3.0.0 - Production
>
> IMP-00002: failed to open D:\Clients\Centocor.DMP for read
> IMP-00021: operating system error - error code (dec 2, hex 0x2)
> Import file: EXPDAT.DMP >
> Import terminated successfully with warnings.
>
> IMP-00009: abnormal end of export file
> IMP-00021: operating system error - error code (dec 9, hex 0x9)
> IMP-00000: Import terminated unsuccessfully
>
> *********************
>
> Any ideas? I've repeated the whole process a few times and still the error
> persists.
>
> TIA.
>
> > Did you FTP in binary mode? I've done several imports using Unix .dmp
> files
> > without any problems.
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> > D. Oakley wrote in message ...
> > >(Oracle 7.3)
> > >
> > >What is the easiest way to export a Unix based instance to an NT
> instance?
> > I
> > >tried using the standard export tool, but the NT DataManager reported
> that
> > >the .dmp was corrupt. Any ideas?
> > >
> > >Thanks.
> > >
> > >
> >
> >

Use OEM to do the export/import. It will eat a little bandwidth but is much easier and foolproof.

Stilian Received on Fri Apr 23 1999 - 16:09:43 CDT