Re: 8i export import to 8.0.5.1 database not a valid export

Exactly; basic trick is to use the lower version tools against the higher version db.
Sometimes, it is required to add these structures you were referring to, and -as Philips pointed out- you could do that by running catexp7 against an V8 database.

Much to my surprise, there's no such thing as a catexp80 for 8.1.6 (aka 8i R2); the (V8.0) export utility runs like a charm against an 8.1.6 database!
I know of one version where the views were the same, but the tools were different: 7.2 vs 7.3 - this is the one exception to the above scenario.

Core dumps may be platform and/or version dependant, and may or may not have anything to do with imp/exp. On NT, I can exp80 from 8.1.6.

hth, Frank

Philip Chee wrote:

> In article <sukbj6djkomc15_at_corp.supernews.com> dave_and_vanna_at_hotmail.com writes:
>
> >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.
>
> I think the theory is that:
> You run catexp7.sql against the 8i database.
> Then run the **v7** export utility against the 8i instance to
> produce a v7 compatible export that can be imported into a v7
> instance.
>
> However I haven't tried this myself.
>
> Philip
>
> ---=====================================================================---
> Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA
> e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932
> Guard us from the she-wolf and the wolf, and guard us from the thief,
> oh Night, and so be good for us to pass.
> --
> þ 20259.03 þ Contentsoftaglinemaysettleduringshipping
  Received on Mon Oct 16 2000 - 12:20:43 CDT