migrating to 9i

From: Vissu <vissuyk_at_yahoo.com>
Date: 15 Apr 2002 13:05:11 -0700
Message-ID: <2bedd6a7.0204151205.5c3f0237_at_posting.google.com>


Hi,

We have 8.0 in production. We want to upgrade to 9i. The upgrade will take a while, in the mean while I'd like to have both databases running on the same box. Is this OK ?.

  1. What kind of problems should I anticipate ? I know that listener port will conflict, can I pick a different port for 9i DB ?
  2. By default it will create a default database at installation time, can I tell it not to do that ?.
  3. I want to migrate the same tables from 8.0 to 9i. What is the best way to achieve this ?. I can think of couple of ways (dump every thing in 8.0 and recreate, manually create it etc), I'd like to hear your opinion.

The platform is Solaris.

Thanks

Vissuk Received on Mon Apr 15 2002 - 22:05:11 CEST

Original text of this message