Re: steps to be followed for migrating data from 8.1.7 database to 9.2.0.5.0

Bhaskar,

The upgrade could be done in multiple ways :

If the OS is getting changed between the two releases , then export data out of the 817 database and
import data into the 92 database.

However if the platforms remain identical : a) You could use the "Database Upgrade Assistant" ( dbua ) to perform this upgrade automatically
b) Or I would prefer to perform these steps manually by running scripts.

There are a lot of considerations that need to be taken care of and you would be better off
reading the Migration Manual { Oracle9i Database Migration Release 2 (9.2) -- Chapter 5 }
before you attempt any of the steps.

Vicchu

Bhaskar wrote:

>We have Oracle 8.1.7 installation containing 5 to 6 databases
>(instances).Now we need to move to 9i(9.2.0.5.0). As the documents and
>guide say that install 9.2.0.1.0 and apply oracle patch 3501955 which
>upgrades this base installation to 9.2.0.5.0, upto this everything
>looks fine. But for migrating the data what exactly need to be done.
>Each database might be of 8-10 GB. It would be more helpful if given
>more detailed explanation the ways to migrate data and the procedure.
>Thanks in advance.
>
>
Received on Fri Jun 18 2004 - 07:27:33 CDT