Re: Import Oracle6-Dump from Novell into Ora8.17 on Win2k

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 09 Mar 2004 18:36:07 +0100
Message-ID: <c2kv6m$89b$1@news4.tilbu1.nb.home.nl>

Bib Endum wrote:

> "Jan Lessing" <lessing_at_med.uni-goettingen.de> a écrit dans le message de
> news:c27ch6$np0$1_at_gwdu112.gwdg.de...
>

>>Hi
>>
>>I've got an old running Oracle 6 Server on a Novell-Netware 4.12 Machine
>>and dumped a complete Database with the exp-tool selecting a user
>>NEURONET to export. Now I just set up a brand new Oracle 8.17 personal
>>edition on a Win2k Machine and want to import the dump-file to the new
>>machine backup the data.
>>

>
>
> I'm not sure, but I think you need to run some IMP/EXP compatibility scripts
> ? In Oracle 7, migrationg from 6, you had to sometime run scripts like
> CATEXP6.sql etc...
>
> But Maybe it was only to be able to export a release 7 DB from an release 6
> export executable. Which is not the case.
>
> Normally, import is upward compatible I think, if you exported with oracle6
> export, you should be able to import with oracle 7,8,9 but there might be
> peculiarities, or you might have to specify some parameters.
>
>

I was about to react in the same manner: You're stuck between upgrades:
afaik, you can import V6 in 7.3.4 max.
8.0 not sure, but do not think so.
8i is a no-no!

-- 

Regards,
Frank van Bortel

Received on Tue Mar 09 2004 - 11:36:07 CST