RE: DB Movement from Sun to AIX ?

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.
>--

--
http://www.freelists.org/webpage/oracle-l