Re: Export from 9i and import to 8i

Norman Dunbar wrote:

> either I'm totally bonkers and have missed your point, or you've missed
> mine :o)

Or it's because I've not yet had my early morning coffee. :-)

> I need to import a dump from 920 to 817 - and that cannot be done if the
> dump is created by the higher version.

Yeah, you're right. I was thinking of lower to higher version (e.g. doing an 7.3 export and importing it with 8 into an 8 database).

> I can do the required export/import if I use a non-HP server, but if
> I use any of my HP boxes, I hit this problem.

What happens if you add rows=n to the exp params? What happens if you run the export from another platform? How about changing the output file to another file system?

I think the error can be classified as:

• an o/s error (not enough space, bad/corrupted filesystem mount) in which case you should have seen a HP-UX error code
• a dinkum bug in the 8.1.7 exporter (maybe because if running against 9?)
• an export/import view problem (which you did not get)

The likeliest one seems to be an o/s error... though it does not explain why a normal 9 export does work.

Hmm.. how about the environment? Maybe the 8.1.7 exporter is picking up the wrong libs? Try doing an (Unix shell) export on SHLIB and set that to your 8.1.7/lib path.

--
Billy