Re: DB Movement from Sun to AIX ?
- From: Thomas Day <tomday2@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 25 Jul 2005 13:43:37 -0400
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
Other related posts:
