Re: Multiple tnsnames.ora files possible?

jmr_at_snowhite.mto.allied.com wrote:

>I have an Oracle 7.3.3 on AIX v4 system. It has the normal tnsnames.ora
>file, and everything works well. What I'm trying to do is have a second
>tnsnames.ora file in a different directory which is used for testing.
>
>When testing, I want to use this file, and not the system file. Is this
>possible? I've tried setting TNS_ADMIN to the fully-qualified path name
>of the second tnsnames.ora file, but sqlplus always uses the main file.
>
>Is there a way that this can easily be done?

Say you have a different tnsnames.ora file in you home directory and that you want to use it from, - say sqlplus

 $ export TNS_ADMIN=$HOME
 $ sqlplus scott/tiger_at_alias_from_private_tnsnames_ora

Works for me...

                                   \\|||//
Erik E. Graversen                  ( 0 0 )          eeg_at_iname.com
_________________________________o00_(~)_00o_____________________