Re: How to change the path of tnsname.ora of SQLNav8? [message #21768] |
Wed, 28 August 2002 13:38 |
andrew again
Messages: 2577 Registered: March 2000
|
Senior Member |
|
|
I believe Oracle products look for tnsnames in the following way (you might have to search on the web to confirm).
1.) current directory
2.) location pointed to by TNS_ADMIN variable (same syntax as PATH)
3.) the one under ..networkadmin for the current ORACLE_HOME you start the program in.
So - create a new environemnt variable called TNS_ADMIN which points to the location of the tnsnames you want to use. Be sure to test all tools, ODBC which may depend on it.
|
|
|