Re: Two Versions of Oracle / Common Database Access

I don't know if I'm interpreting your post correctly. If all you want to do is to use the 9.2.0 software to access the 9.0.1 database, I think you just have to change ORACLE_HOME. If you want to clone your database, so you have the same db running under each version, you can copy the db files.

We're still running 8.1.7 here, so I don't know if the database structure changed between 9.0.1 and 9.2.0. However, I used to do something like this all the time with 8.1.x databases (to test data warehouse stuff). To quickly clone a database, all we did was copy the datafiles, logfiles, controlfiles, etc to the new host (or in your case, the new directory hierarchy).

You should be aware of one glitch with the above technique, however. Since the files are an exact duplicate of the original, you won't be able to use RMAN to manage backup/recovery of both databases (since the database ID - dbid - would be identical and RMAN doesn't like that).

B. Kloppt wrote:
> 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?
Received on Fri Sep 20 2002 - 15:13:12 CDT