Re: Preferable option for moving data from Oracle 9i into Oracle 10g??

The oracle-l mailing list was moved to freelists.org some time ago.

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

Its archives can be accessed here:

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

Much changed in the Oracle Cost Based Optimizer (CBO) between 8i and 9i (more specifically, 8.1.7 to 9.2).
A change that affected my employer's code was transitivity. A lack of explicit joins in 9.2 that were not required in 8.1.7 caused nested loops plans to go to hash joins.

Wolfgang Breifling has a series of papers on his site that may be helpful:
http://www.centrexcc.com/

the one that may be most relevant to you is "What is new in the Oracle 9i CBO ".

If you have Metalink support, I'd suggest that your DBA start with the following notes:
Note:258945.1 - Upgrading from 8.1.X to 9.X - Subquery Issues - Diagnosing and Resolving
Note:258167.1 - Upgrading from 8.1.X to 9.X - Potential Query Tuning Related Issues

As always, Oracle provides its documentation online: http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=1

Its "upgrade guide" can be found here:
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10763/toc.htm

hth.

-bdbafh Received on Sun Feb 20 2005 - 11:21:57 CST