Re: Migrating from Oracle 7.3x to Oracle 8.04

Pretty straightforward, but you better follow the directions carefully. I hosed the first database I tried to convert when I started up the v7 database with the v8 software. At that point, I had to rebuild the database (just used v8 to do this) and imported the v7 export. If you do only one thing, make a backup :-)

The process is laid out in the Oracle 8 server installation guide, in the chapter appropriately entitled: "Upgrading and Migrating". All in all, it went pretty smoothly. You just have to make sure your ORACLE_HOME variable is set correctly at each step. Also, you'll have to update any ProC makefiles you're using - a lot changed there. Except for the test database I hosed, we used the Migration Path, as opposed to the Upgrade path.

----dale

nbrown_at_epnet.com wrote:
>
> Hi-
>
> Can anyone relay to me any 'war stories' related to migrating from Oracle
> 7.3x to Oracle 8.04 (or any Oracle 7 flavor to any Oracle 8 flavor). We are
> looking into doing this, and I am interested in knowing if this is a straight
> forward process, or if it is fraught with nightmares and hidden 'gotchas'. I
> have some people telling me this can be achieved in a day or two (the
> database in question is not that big - probably 30 or so tables, several
> packages, procedures etc - and is interfaced via a C++ front end), but I'm
> not willing to buy that yet. If anyone can 'school' me on this I'd appreciate
> it (and if anyone can suggest a good checklist or source of a good checklist
> for this process - even better!) Thanks a lot...
>
> Nathaniel Brown
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Dec 03 1998 - 15:44:42 CST