Re: Migrating from Oracle 7.3.4.4 to 8.x

The change in the rowid format is one important issue and there are a number of init.ora parameters that you may want to use. There is a migration utility and you should probably use that to do the migration although the export - import will also work. Especially, check out your default date format.

Kenneth C Stahl wrote:

> I will soon be given the opportunity to migrate some databases from Oracle
> 7.3.4.0 on a UW 2.1.2 platform to Oracle 8.x on SunOS5.6/Solaris 2.6.
>
> Are there any hidden "gotchas" that I should be aware of? I plan to build
> the databases using the same scripts that I used to build the 7.3.4.0. We
> have no immediate plans to use any specific 8.x features above and beyond
> those that are available in 7.3.4 - however, are there any that I should
> probably consider in constructing the database?
>
> Once the database is read I just plan to do a full export of the old
> database and then perform the import user-by-user.
>
> Currently the application is using MTS because of the large number of users
> (cira 80). I've tried to follow some of the discussions about MTS on these
> groups and from what I can surmise it may not be necessary to use MTS under
> Oracle 8. Is this true? Is there any negative aspects about setting up MTS
> anyhow?
>
> What about sqlnet issues. I understand that with Oracle 8 I'll be using
> Net8. Is there any major differences in how the listner.ora is set up? What
> about tnsnames.ora?
>
> Are there any major tuning issues that change dramatically?
>
> I do plan to get a book on Oracle 8 DBA and Oracle 8 Tuning before I
> actually start the work, but I also think it is worthwhile to get imput
> from those who are already using Oracle 8.
Received on Fri Dec 17 1999 - 13:00:28 CST