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

Perhaps I am missing something. It seems there are enough folks who believe it to be possible to take an export from a newer database and import it into an older database that maybe my assumptions, based upon trying it, are not valid.
Theoretically it is possible to take an export of a version 7 database, run catexp7.sql against an 8i database and then import the version 7 export file into the 8i database. I say theoretically because in my experience this causes core dumps in an 8i database (8.1.6.2 to be exact).

However, if one exports from an 8i database, how is the version 7 imp utility supposed to recognize the content of the 8i export file? How would the version 8i import utility understand the stucture of the version 7 exp/imp datadictionary objects? And assuming it could, how would one have a version 8 import utility on a machine running version 7?

If someone could be kind enough to tell me the procedures they followed to import a newer version export file into an older version database, I would be happy to try it. And I *do* hope it works, because I would like to do exactly that.

--
Dave A


"frank" <fbortel_at_home.nl> wrote in message news:39E9C2D9.919CF267_at_home.nl...


> 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

> > >

>