Re: migration from 8.1.5 to 8.1.7

From: Ralf Zwanziger <goldensurfer_at_gmx.de>
Date: Thu, 10 May 2001 06:18:08 GMT
Message-ID: <3afa3166.259660512@news.fth.sbs.de>

Hi Martin,

>I want to move a database running under Win NT with Oracle 8.1.5 to
>another computer running Win NT with Oracle 8.1.7. I've already copied
>the datafiles and created/started the instance on the other server.

copying the datafiles is no good idea, because you can't be sure that the datafile structure is the same between two versions of oracle. A way that should work is:

make a full export of your data inside your 8.1.5 installation:

exp userid=system/manager full=y consistent=y file=dump.exp log=dump.log

copy the dump.exp to the machine with the 8.1.7 installation
import the file to your 8.1.7 database

Now you should be able to access your "old" data on the new installation.

Bye,
Ralf Received on Thu May 10 2001 - 01:18:08 CDT