Re: DB Movement from Sun to AIX ?
- From: Jamie Kinney <oracledude@xxxxxxxxx>
- To: tomday2@xxxxxxxxx
- Date: Tue, 26 Jul 2005 09:11:25 -0700
I'm currently in the middle of a Oracle 9i cross-platform migration
using the materialized view approach. I also recommend that you try
this method. I also recommend that you take a look at DDL Wizard, a
free tool available at http://www.ddlwizard.com/ which can be used to
easily generate and batch modify the DDL for your new system. I used
this tool to generate DDL scripts with new schema names and storage
characteristics.
The only painful part of the process is the initial complete snapshot
refresh of VERY large tables. Prior to 10g, this data is moved
serially, which means that tables might take a day or more to
instantiate. Be sure to set undo_retention appropriately and give
enough space to your undo_tablespace.
-Jamie
On 7/25/05, Thomas Day <tomday2@xxxxxxxxx> wrote:
> How about materialized views?
>
> Create your tables on the AIX box and then create materialized views
> using those tables to replicate the Sun data.
>
> When everything's up to speed, cut your users off, do one last
> refresh, and drop the materialized views on the AIX box. The
> underlying tables will remain with their data. Change the entry in
> ONAMES and your users start up in the AIX box right where they left
> off on the Sun.
>
> It's not quite as simple as that. Spend about 2 months planning it
> and rehearse it at least twice.
>
> We used it to migrate an 80G database to AIX. User downtime was 15 minutes.
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
