RE: 8i to 9i upgrade

  • From: Guang Mei <GMei@xxxxxx>
  • To: "'nnahata@xxxxxxxxxxxx'" <nnahata@xxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 17 Feb 2005 08:09:29 -0500

I would say to fully test your applications on your test 9i system before
you migrate. Some sql query plan can change due to oracle's internal
optmizer change. Also I would use oracle exp/imp to move schema data.

HTH.

Guang

-----Original Message-----
From: Nahata, Naveen (US - Hyderabad) [mailto:nnahata@xxxxxxxxxxxx]
Sent: Wednesday, February 16, 2005 8:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: 8i to 9i upgrade


Hi Friends,
We are planning an upgrade from 8i (8.1.7.4) to 9i on HP-UX platform.
The database size is close to 500 GB.

I'm looking for best practices, Do's and Don'ts, possible pitfalls and
alternate strategies for the same.

Please let me know your advice/experience regarding the above.

Regards,
Naveen


This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law.  If
you are not the intended recipient, you should delete this message.  Any
disclosure, copying, or distribution of this message, or the taking of any
action based on it, is strictly prohibited.

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

************************************************************************* 
PRIVILEGED AND CONFIDENTIAL: 
This communication, including attachments, is for the exclusive use of
addressee and may contain proprietary, confidential and/or privileged
information.  If you are not the intended recipient, any use, copying,
disclosure, dissemination or distribution is strictly prohibited.  If you
are not the intended recipient, please notify the sender immediately by
return e-mail, delete this communication and destroy all copies.  
*************************************************************************
--
//www.freelists.org/webpage/oracle-l

Other related posts: