reading servers tnsnames from sql session
Hello,
I have the need to create database links from test instances to production instances every now and then.
But I'm not the database administrator so I dodn't have access to the servers operating system to find out what tns alias the target instance has on this server.
Is there a simple way to list all tns aliasses in the servers tnsnames.ora through a SQL session?
By "simple" I mean without issuing OS commands or accessing the servers tnsnames.ora through an oracle directory.
bye
TPD