1. I have not used Oracle's migration scripts, I just thought this way I could start 9i clean. So if there is any problem, it's 9i problem, not 8i or migration problem. 2. Also I can afford some down time during exp/imp. Guang -----Original Message----- From: Nahata, Naveen (US - Hyderabad) [mailto:nnahata@xxxxxxxxxxxx] Sent: Thursday, February 17, 2005 8:16 AM To: Guang Mei; oracle-l@xxxxxxxxxxxxx Subject: RE: 8i to 9i upgrade Thanks Guang, Any specific reason why you prefer export/import? Naveen -----Original Message----- From: Guang Mei [mailto:GMei@xxxxxx] Sent: Thursday, February 17, 2005 6:39 PM To: Nahata, Naveen (US - Hyderabad); oracle-l@xxxxxxxxxxxxx Subject: RE: 8i to 9i upgrade 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 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. ************************************************************************* 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