Re: moving a database from 8.0.5 to 8.1.7

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 30 Aug 2001 10:43:25 +0200
Message-ID: <torvseml5bpfc9@news.demon.nl>

"Christoph Kukulies" <kuku_at_gil.physik.rwth-aachen.de> wrote in message news:9mkrjm$9qi$1_at_nets3.rz.RWTH-Aachen.DE...
> I have a database under 8.0.5 and would like to move it most elegantly
> to 8.1.7. Do I have to use EXP80 or is there another way, e.g. to copy
> the database files over to the 8.1.7 server?
>
> --
> Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de

Assuming no cross-platform operation is involved, bringing an 8.0 instance to 8i only requires upgrading the datadictionary. The Oracle Migration Assistant will take care of that. Don't forget to bump your compatible parameter after migration, Oracle tools usually leave it unaffected.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Aug 30 2001 - 03:43:25 CDT