miercuri, 3 aprilie 2013

Where are those dblinks?


This is the first post here, so i won't reveal any dark secret. Most of you are, sometimes, asking yourselves about what db links the database already has, created and available. If you cannot use any GUI client (toad, oracle sql developer, etc) and have sys rights you can:

select * from dba_db_links;

and the result will be pretty straight forward.

Here it is the structure of this dba view:


Name     Null     Type           
-------- -------- -------------- 
OWNER    NOT NULL VARCHAR2(30)   
DB_LINK  NOT NULL VARCHAR2(128)  
USERNAME          VARCHAR2(30)   
HOST              VARCHAR2(2000) 
CREATED  NOT NULL DATE 

Legend:

owner=the user who owns the dblink (if it is public, it goes for everyone)
db_link=the actual name of it
username=the user you under will you connect in the specified database
host=hostname (ip), port and SID (service name) of the linked database
created 

Un comentariu: