Re: Oracle 8i Migration

From: Brian Peasland <oracle_dba_at_qwest.net>
Date: Wed, 11 Jul 2001 13:16:29 GMT
Message-ID: <3B4C51AD.13B09667@qwest.net>

Joshua,

> I have a query regarding the migration from Oracle 8.0.5.2 to Oracle 8.1.7,

Technically speaking, this is called an "upgrade" not a "migration".

> We have a table with 120 million records & we have enabled partitioned
> option. When we migrate from Oracle 8 to Oracle 8i , what procedure need to
> be followed for partitioned table ?

You do not have to do anything for the partitioned table. It will still be partitioned when your upgrade is complete.

> Normally we will be using U0080050.sql to migrate, apart from this what else
> do we need to follow ?

Take a cold backup both before and after your upgrade script is run...just in case....

HTH,
Brian Received on Wed Jul 11 2001 - 08:16:29 CDT