Re: Using both Oracle9i and 10g on the same system

On 11 Jan, 12:24, Rom1 <no-addr..._at_information.com> wrote:
> Hello there,
>
> I need to run quite tricky sql statements on two different databases
> from a windows server. One DB is on oracle9, the other on oracle10.
>
> Which client would you use/prefer if not installing both?
>
> I guess that the program running the statements will use the integrated
> variables and I cant define two ORACLE_HOME on the system, can I?
>
> Some feedbacks I got was that you should always use the latest client
> which should be backward compatible, and others would consider that the
> v10 DB should take in charge a connection from a v9 client and handle it
> as required.
>
> Any opinion on this matter is greatly appreciated.
>
> Thank you by advance for your help.
>
> Romain

A 10g client will quite happily connect to a 9i instance. For the sake of simplicity, I'd just do that.

HTH -g Received on Fri Jan 11 2008 - 06:29:50 CST