Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DB Movement from Sun to AIX ?

Re: DB Movement from Sun to AIX ?

From: Thomas Day <tomday2_at_gmail.com>
Date: Mon, 25 Jul 2005 13:43:37 -0400
Message-ID: <a8c5045905072510434ecc97a8@mail.gmail.com>


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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 25 2005 - 12:45:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US