Question / Problem:
MarkView All Components - How do I consolidate multiple tnsnames.ora files?
Answer / Solution:
If you have multiple copies of tnsnames.ora files on your pc and want to have an easy way to update them all :
1. Put your most up to date version in a central location, e.g. c:\winnt\tnsnames.ora
2. Go through all other copies on your hard drive and replace the contents with ifile="c:\winnt\tnsnames.ora"
3. From now on all tnsnames files will read from your one main version of it.