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)
CREATED NOT NULL DATE
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