Re: Using both Oracle9i and 10g on the same system
Date: Fri, 11 Jan 2008 04:29:50 -0800 (PST)
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.
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