Re: How can I migrate and upgrade the database ???

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 28 Oct 2001 20:05:33 +0100
Message-ID: <ttom5uatodv183@corp.supernews.com>

"Janet" <janet.zh_at_3web.net> wrote in message news:3bdc4869_at_news.cybersurf.net...
> Hi, There is an Oracle production database PRO_DB(7.3) with many client
data
> in Sever P1 (UNIX), and now I bought a new Server P2 (UNIX). I want to
move
> the Oracle database to new server with 8.1.7.
> How can I migrate and upgrade the database PRO_DB to new Server P2 with
> Oracle 8.1.7?
>
> Thanks
>
>
> Janet
>
>
>
>
>

As the rowid format changed in 8.0, and you have two systems, the best method looks like

-create an empty database on the new server
- optionally precreate all tablespaces
- export the database on the old system, using exp from 7.3
- ftp the export in binary mode to the new server
- import the database.

As the rowid format has changed in 8.0 (and beyond) you need to ascertain none of your applications is *directly* working with rowids

Of course this scenario is also described in the Oracle provided migration docs

Hth,

Sybrand Bakker
Senior Oracle DBA Received on Sun Oct 28 2001 - 13:05:33 CST