I have had oracle 9i installed for couple years where I was unable to connec t to an Oracle 10g database. As a result I installed 10G client. If I use TOAD and specifically select the home for 10g I can connect. Otherwise, I cannot connect to the 10g database. However, my problem is that my application uses whatever the default Oracle home is. As a result it tries to connect with 9i which does not work. Is there a way to change my default Oracle home to the 10 g home?
FYI - When I installed 10 g client I used the defualt settings.