Re: Upgrade to Oracle8

First of all, you must take a valid cold backup of your final 7 database. Then you install 8 on a separate $ORACLE_HOME (/oracle/product/8.x.x). In this way, the 7 code is left intact. As for the Database files, they need to be converted to 8. This can be done in one of two ways:
1) export/import. The import would be to a new location and your 7 database is left intact. You now have both Oracle 7 and 8 available to you.

     OR
2) I don't remember the name of this 2nd option but essentially it upgrades the existing Oracle7 database to Oracle8 in place. This destroys the ability to reopen this database with Oracle 7 ever again. But if you were forced to go back to Oracle7, a restore of the cold backup together with the Oracle7 code that as I mentioned earlier was left intact in its own ORACLE_HOME (/oracle/product/7.x.x) would get you there.

Javier

Chuck Hamilton wrote:

> We are considering an upgrade from Oracle7 to Oracle8. If once we are
> running on 8 we find performance problems or some other reason to go
> back to 7, how difficult is it and what needs to be done.
> --
> Chuck Hamilton
> chuckh_at_safeaccess.net
>
> Never share a foxhole with anyone braver than yourself!

Received on Tue Jan 12 1999 - 22:18:35 CST