RE: Database Upgrade/Migration Dilemma

LMAO! rr  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rick Weiss Sent: Wednesday, October 25, 2006 11:13 PM To: oracle-l_at_freelists.org
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_at_safmt.org
(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.

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