Re: Oracle 7.1 -> 7.3 migration

I've ugraded recently from 7.1 to 7.3 and had no major problems. Here is the basic steps:

1. Export your entire DB - perform a FULL export to get all data.
2. Delete your entire DB.
3. Install the new version of Oracle.
4. Recreate your DB.
5. Import your saved data - perform a FULL import to get all your data.

We only had to change some of our Apps. The new Oralce Precompiler on the HP 10.20 had us make some minor mods.

We had to change the way we implemented Database Links. These were done with OPS$ accounts and did not specify a user/password. However, 7.3 did not seem to support this, so, we changed to specifiying an account in our DB link definition.

Also, SQLDBA gets replaced with SVRMGR so we had to modify all or our DBA scripts to use the new code. No changes were required to the actual code however.

Sandy Received on Thu Jan 15 1998 - 00:00:00 CST