Thanks Guang, Any specific reason why you prefer export/import? Naveen -----Original Message----- From: Guang Mei [mailto:GMei@xxxxxx]=20 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. -- //www.freelists.org/webpage/oracle-l