Export from 9i and import to 8i

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 23 Jan 2003 08:21:36 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703355249@lnewton.leeds.lfs.co.uk>

Morning Billy,

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

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

The views problem doesn't seem to be the cause - I only get an 'export tables not installed' error message if I try to export from the 920 user using a 734 version of exp.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Billy Verreynne [mailto:vslabs_at_onwe.co.za] Posted At: Thursday, January 23, 2003 7:50 AM Posted To: server
Conversation: Export from 9i and import to 8i Subject: Re: Export from 9i and import to 8i

Norman Dunbar wrote:

> login to 817 account
> Attempt to export 920 user using 817 software

How about trying it the other way around Norman? Running exp v9.x to create
the dump file and importing that using imp v8.x?

Export/import use their own set of views - could likely be that the 817 exp
trying to export the 9.2 user gets its knickers in a knot due to the 9.2

export views.

--
Billy

Received on Thu Jan 23 2003 - 02:21:36 CST