RE: Database Upgrade/Migration Dilemma
- From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
- To: <RWeiss@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 26 Oct 2006 20:37:36 -0600
LMAO!
rr
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rick Weiss
Sent: Wednesday, October 25, 2006 11:13 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Database Upgrade/Migration Dilemma
I just had an interesting and disturbing discussion with damagement and
wanted to run this by the DBA Gods that read this list.
We are planning to migrate out production environment from Oracle 8i
(8.1.6) on AIX to Oracle 10g (10.2) on Linux. My current plant is to do
the data moves (about 150 tables) as CTAS via database links. (are there
better options? exp/imp won't go back that far) The biggest kicker came
in this afternoon - our Java head wants to do the migration with the
application up and accessible.
This just seems to me to be courting disaster. My suggestion was to
take everything down, back up the entire environment and then do the
moves prior to repointing the applications and bringing them up.
Another kicker is they don't want to test prior to pulling the trigger.
The worst thing is they made the decision while I was out of town @ OOW.
Should I get my resume' ready?
Thank you for any insights you may have.
Rick Weiss
Oracle Database Administrator
Student Assistance Foundation
P.O.Box 203101
2500 Broadway
Helena, MT 59620-3101
rweiss@xxxxxxxxx
(406) 495-7356
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.
Other related posts:
