Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Preferable option for moving data from Oracle 9i into Oracle 10g??

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

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 18 Feb 2005 23:22:50 GMT
Message-ID: <421678b9.1391380048@localhost>


If db is small use imp/exp
If db is large use upgrade steps

On 18 Feb 2005 09:58:48 -0800, qazmlp1209_at_rediffmail.com (qazmlp) wrote:

>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?

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Feb 18 2005 - 17:22:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US