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

Home -> Community -> Usenet -> c.d.o.misc -> Two Versions of Oracle / Common Database Access

Two Versions of Oracle / Common Database Access

From: B. Kloppt <b_kloppt_at_my-deja.com>
Date: 20 Sep 2002 09:39:06 -0700
Message-ID: <3717b54f.0209200839.29a6edbb@posting.google.com>


hi,

i've seen postings about this subject a few times yet i never saw any real answer to my question.
i have oracle 9.0.1 and oracle 9.2.0 installed on the same linux machine.
both reside in their respective directories:
/opt/oracle/product/9.0.1/
/opt/oracle/product/9.2.0/

using a script i can change the environment to the version i want to use.
my ORACLE_HOME variable, among others, is then set accordingly. the problem is this:
i started with version 9.0.1 and created a few databases that i now want to use with the 9.2.0.
instead of using exp and imp to export the data out of the old and import into the new, i would assume there would be an easier way. since the database files seem to reside in their respective directories under /opt/oracle/admin/, i don't see how they could be version dependent.
how would i go about using the databases i created under 9.0.1 with 9.2.0?
is there anyone who could direct me to some clear documentation or perhaps give me step-by-step instructions?

i would be very grateful for any help.

thanks,

b Received on Fri Sep 20 2002 - 11:39:06 CDT

Original text of this message

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