RE: DB Movement from Sun to AIX ?
- From: "David Wendelken" <davewendelken@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Jul 2005 14:43:35 -0400
Someone was posting earlier about an upgrade problem with changing character
sets when switching to a new oracle database. It seemed that the
import/export process was a big part of the problem, that internally, Oracle
was ok about 8-bit characters in an ascii database.
I wonder if this approach would help get around that...
>-----Original Message-----
>
>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:
