Re: 8i export import to 8.0.5.1 database not a valid export file, header failed verification

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 21 Oct 2000 23:50:01 +1000
Message-ID: <39f1916a@news.iprimus.com.au>

"Bruno Georges" <bruno_at_xbridge.com> wrote in message news:39F19592.71929955_at_xbridge.com...
Hi,
I am facing similar problem, and the difference between my versions are even smaller
exp from 8.1.6 on a linux RH6.2 box
imp to 8.1.5 on a Sol2.6/E250
My understanding is that the only solution is to upgrade from 8.1.5 to 8.1.6 Is that true ?

---

We may be talking bizarre o/s-specific quirks that mean that this is so, but it certainly isn't the general case. The general case remains that higher-version of the export/import executables cannot be applied to a lower version of the database, but a lower-version of the executable can be applied against a higher version of the database.

Hence I can run exp73 against an 8.1.5 database (and I've done it). That generates a 7.3-compliant export dump file, which can then be imported into the 7.3 database (if you've used any of the new features in 8i, of course, you lose them in the translation).

You cannot, however, (at least reliably) run exp (version 8.1.5) against the 7.3 database.

In your specific case, you can use the 8.1.5 executables against the 8.1.6 database to generate an 8.1.5-compliant dump file. The fact that you are crossing O/Ses at the same time might not allow that to work, though.

Incidentally, please don't post in HTML... it makes plain text replies a pain in the neck to sort out.

Regards
HJR

---

Thanks for any directions/help.
Regards
Bruno Georges
Senior Developer
Xbridge Ltd
bruno_at_xbridge.com

frank wrote:
Have you tried? This seems to be one of these rare occasions... Dave A wrote:
> It is possible to export from an older version database and import it into
 a
> newer version database, but it is rarely, if ever, possible to export from
 a
> newer version database and import it into an older version database.
>
> --
> Dave A
>
> "frank" <fbortel_at_home.nl> wrote in message
 news:39E623FF.439FB1C2_at_home.nl...
> > I can run the V8.0 export tool against a 8.1.6 database,
> > and an import, too (8.0 tool, 8.1 db)
> >
> > hth, grtz Frank
> >
> > Bill Baker wrote:
> >
> > > Hi all,
> > >
> > > I'm having great fun with Oracles export and import utilities, any
 ideas
> > > would be appreciated.
> > >
> > > I'm tring to import a dump file that was exported from an 8i database.
> > > Export was done on a 2000 workstation(I think it was 8i tools),
 pointed
> > > at an Oracle Solaris 8i database. The place I'm importing to is an
> > > 8.0.5 linux database. I keep getting the same message below:
> > > Connected to: Oracle8 Enterprise Edition Release 8.0.5.1.0 -
 Production
> > > With the Partitioning and Objects options
> > > PL/SQL Release 8.0.5.1.0 - Production
> > >
> > > IMP-00010: not a valid export file, header failed verification
> > > IMP-00000: Import terminated unsuccessfully
> > >
> > > I've researched this a bit, and found some postings which imply that
 you
> > > can't use exports from the "exp" tool that are higher version than the
> > > database you are trying to import to. Any ways to work around this?
> > >
> > > It's really hard to believe that Oracle would change the dump files
 that
> > > much to the point where they would be incompatible in the same major
> > > oracle version number.
> > >
> > > Thanks for any suggestions in ad
> > > --
> > > Bill Baker
> > > Paperless Business Systems
> > > (206)256-0771
> > > www.paperlessbusiness.com
> > > www.elephantsandants.com
> >
Received on Sat Oct 21 2000 - 08:50:01 CDT