Home » SQL & PL/SQL » SQL & PL/SQL » know the @
know the @ [message #254166] Thu, 26 July 2007 01:06 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii all

i connect to the database by
reps/reps@prd

is there a table that hold the connection after the @


if it is not impossible is there any table that holds the server name that i connect to it

Thanks for everyone helped and helping me
Re: know the @ [message #254174 is a reply to message #254166] Thu, 26 July 2007 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
V$DBLINK

Regards
Michel
Re: know the @ [message #254181 is a reply to message #254166] Thu, 26 July 2007 01:49 Go to previous messageGo to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member
if u have set this parameter in pfile you will get services names by querying for server_names from v$parameter.


*.service_names='test,orcl'

You can see all the services in oracle net manger service naming..isnt it?

hope its helpful else soneone else will help both of us.

regards
unus
Re: know the @ [message #254203 is a reply to message #254166] Thu, 26 July 2007 02:46 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
If you use tnsnames to connect through a listener, there is nothing in the database that contains the part after the @-sign. This is an alias defined in tnsnames.ora.
Previous Topic: how to get first day in the date
Next Topic: dumb title.
Goto Forum:
  


Current Time: Mon Dec 05 08:50:13 CST 2016

Total time taken to generate the page: 0.24679 seconds