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: <oracle-l-bounce_at_freelists.org>
Date: Tue, 26 Jul 2005 17:05:35 +0530
Message-ID: <B5587533FCBD4344ADB8290B3EDDA122073ED58E@kecmsg14.ad.infosys.com>

Some Dumb Questions here Thomas

  1. The Client only has Oracle Licenses for 8i on SUN & 9i on AIX. Is it possible for the materialized view setup in the 9i/AIX DB to pull data from the source 8i/SUN DB OR does the source 8i/SUN DB also needs to be first migrated to 9i on SUN for the target 9i/AIX DB to pull data therefrom?
  2. Is it possible to use a combination i.e. 1st use CTAS with a < date condition to populate historical data Followed by usage of materialized view to complete the balance refresh?
  3. Is parallelization clauses/ parameters setup possible in the materialized view refresh as exists in CTAS parallel (degree n)?
  4. What would be the performance overhead on the production source 8i/SUN DB due to the refresh happening to the target 9i/AIX DB as part of materialized view?

Excuse my communication skills

P.S. Any other ideas folks?

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Monday, July 25, 2005 11:19 PM
To: tomday2_at_gmail.com; oracle-l_at_freelists.org Subject: RE: DB Movement from Sun to AIX ?

Thomas,

Man! That's an interesting idea!

Did it work well for you? Any downsides?

Tom

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day
Sent: Monday, July 25, 2005 1:44 PM
To: oracle-l_at_freelists.org
Subject: Re: DB Movement from Sun to AIX ?

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.

Received on Tue Jul 26 2005 - 06:38:50 CDT

Original text of this message

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