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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Problems when exporting from 8.1.6 and importing on 8.1.5

Re: Problems when exporting from 8.1.6 and importing on 8.1.5

From: PDP <wasteofspace_at_mindspring.com>
Date: Sat, 14 Apr 2001 15:13:28 -0500
Message-ID: <9bab24$lpb$1@slb1.atl.mindspring.net>

There is an article on TechNet that discusses this issue thoroughly. The condensed version is to use the export from the lowest version and it will work. I have had to deal with this several times recently and it will work to export using 8.1.5. In other words, find a PC to install (if you don't have one already) the 8.1.5 client on, export from your 8.1.6 database, the import into the 8.1.5 database. Trying to copy just the import/export executables leads to copying virtually every oracle dll also. Not recommended.
Good luck. - Paul D. Pest

"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message news:986982252.2660.0.nnrp-09.c30bdde2_at_news.demon.co.uk...
> Markus
>
> Can you use EXP from 815 to export from 816 database? That should work
> according to NG folklore. Also, I seem to remember reading somewhere that
> you can run the 815 ?/rdbms/admin/catexp.sql on your 816 database to build
> 815 compatible export scenario, but I wouldn't be the one to have to test
> that...
>
> Andrew
>
> "Markus Böhmer" <markus.boehmer_at_schaefer-shop.de> wrote in message
> news:3AD1BC45.10A1FE3F_at_schaefer-shop.de...
> > Hi Folks,
> >
> > I try to import an exportfile generated with Oracle 8.1.6 into an 8.1.5
 database.
> > The error messages are the following:
> >
> > IMP-00010: not a valid export file, header failed verification
> > Cause: Either the file was not generated by Export or it was corrupted.
> > Action: If the file was indeed generated by Export, report this an
> > Import bug
> > and submit the export file to customer support.
> >
> > IMP-00021: operating system error - error code (dec num, hex 0x num)
> > Cause: An operating system error has occurred.
> > Action: Look up the referenced message in your operating system-specific
 Ora-cle
> > documentation and take appropriate action.
> >
> > IMP-00000: import terminated unsuccessfully
> > Cause: Import encountered an Oracle error.
> > Action: Look up the accompanying Oracle message in the ORA message
 chap-ters
> > of this manual, and take appropriate action.
> >
> > Well, the third one is clear.
> > But what do the two above mean?
> > The file was generated by export and there have been no errors at the
> > file transfer.
> >
> > I hope that someone has a suggestion.
> >
> > Greetings
> > Markus
> > --
> > Markus Böhmer
> > SSI Schäfer Shop GmbH
> > mailto:markus.boehmer_at_schaefer-shop.de
>
>
Received on Sat Apr 14 2001 - 15:13:28 CDT

Original text of this message

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