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