RE: DB Movement from Sun to AIX ?
- To: <tomday2@xxxxxxxxx>
- Date: Tue, 26 Jul 2005 17:05:35 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: Monday, July 25, 2005 11:19 PM
To: tomday2@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
Sent: Monday, July 25, 2005 1:44 PM
To: oracle-l@xxxxxxxxxxxxx
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.
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely
for the use of the addressee(s). If you are not the intended recipient, please
notify the sender by e-mail and delete the original message. Further, you are
not to copy, disclose, or distribute this e-mail or its contents to any other
person and any such actions are unlawful. This e-mail may contain viruses.
Infosys has taken every reasonable precaution to minimize this risk, but is not
liable for any damage you may sustain as a result of any virus in this e-mail.
You should carry out your own virus checks before opening the e-mail or
attachment. Infosys reserves the right to monitor and review the content of all
messages sent to or from this e-mail address. Messages sent to or from this
e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***
--
//www.freelists.org/webpage/oracle-l
Other related posts:
