Preferable option for moving data from Oracle 9i into Oracle 10g??

From: qazmlp <qazmlp1209_at_rediffmail.com>
Date: 18 Feb 2005 09:58:48 -0800
Message-ID: <db9bbf31.0502180958.44f27495@posting.google.com>

We have a requirement to move to Oracle 10g from Oracle 9i. As I understand, there are 2 options to do it: Option-1)

Execute Oracle 9i->10g upgrade steps. The data which was in Oracle 9i is now available in Oracle 10g database automatically.

Option-2)

Export the data contained in Oracle 9i, using Oracle 9i version of 'exp' tool
Clean-up the Oracle 9i database and create a new Oracle 10g database.
Do an import of the previously exported data into new Oracle 10g database, using Oracle 10g version of 'imp' tool.

Could anybody tell about in which scenarios each of the above mechanism is preferable to the other one? Received on Fri Feb 18 2005 - 11:58:48 CST