Is it possible to create a dns file and/or link to tables in an Oracle database that is not in the tnanames.ora file?
I have all the TNS info to connect to the database in question, but have not been able to figure out how to connect to it.
The obvious solution would be to add the database to the tnsnames.ora file, but that won't work because the database is not in the corporate tnsnames file which automatically overwrites the local file during the login script.
_________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
I have all the TNS info to connect to the database in question, but have not been able to figure out how to connect to it.
The obvious solution would be to add the database to the tnsnames.ora file, but that won't work because the database is not in the corporate tnsnames file which automatically overwrites the local file during the login script.
_________
Rott Paws
...It's not a bug. It's an undocumented feature!!!
