Re: 8i to 10g migration

From: Paula Stankus <paulastankus_at_yahoo.com>
Date: Tue, 18 Jul 2006 04:07:05 -0700 (PDT)
Message-ID: <20060718110705.56056.qmail@web33213.mail.mud.yahoo.com>

We have the following environment:    

-a great deal of database links
-materialized views over database links
-Oracle 8.1.7
-Solaris 2.9

• .Net with ODP
  -Powerbuilder
  -Data Junction
  -Siebel
  -Cobol programs precompiled
  

  and are planning a migration from 8.1.7 to 10g.    

  Where is the best place to look for gotchas:    

-database links
-hints that have been desupported
-Issues with .Net
-Issues with Cobol precompilers
-Performance concerns
-migration path - direct migration or export/import????
   

  I am planning to clone production, give ample time to multiple development teams to test this out. I am planning to take sample queries generating execution plans in both environments and traces. I am planning a stress-test.    

  Any advice would be greatly appreciated.
-required PL/SQL changes
                         

---

See the all-new, redesigned Yahoo.com. Check it out.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 18 2006 - 06:07:05 CDT