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