Re: 9i to 10g migration

From: <mccmx_at_hotmail.com>
Date: 22 Nov 2005 00:27:35 -0800
Message-ID: <1132648055.474810.35560@z14g2000cwz.googlegroups.com>

> I thought there might be an UPGRADE option to the DUPLICATE command, but
> docs do not seem to list one. I would appreciate any input as to what I am
> screwing up here, or how to accomplish what I am trying to do. I would
> prefer not to copy the os files over as that would require an outage of the
> production db to develop the test db, and a longer outage when we switch
> over, but that seems to be the only option right now.
>
> Thanks for any and all help.

As far as I'm aware there is no way to upgrade and restore/duplicate at the same time.

You will have to incur some downtime in order to do this upgrade. However, if you plan this well and do some pre-implementation dry runs, you can iron out any problems and keep the required downtime to a minimum. Check out the official Oracle upgrade/migration document on docs.oracle.com.

If the database is small you may be able to get away with the exp/imp method. Otherwise use the Upgrade Assistant. Received on Tue Nov 22 2005 - 02:27:35 CST