OraFAQ Forum: Server Administration » Get all dblink names?

Home » RDBMS Server » Server Administration » Get all dblink names?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Get all dblink names? [message #122101]

Thu, 02 June 2005 17:49

sridas
Messages: 5
Registered: March 2005

Junior Member

Hello all,
This is a followup to my previous question, can someone tell me how to view the dblinks created in a database?

is there a slect * from v$....
that I can use to see the dblinks on the database.

thanks everyone
das

Report message to a moderator

Re: Get all dblink names? [message #122117 is a reply to message #122101]

Fri, 03 June 2005 00:23

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

V$DBLINK

Report message to a moderator

Re: Get all dblink names? [message #122785 is a reply to message #122101]

Wed, 08 June 2005 09:14

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

select * From all_db_links ; or select * from dba_db_links ; from system user

or select * From user_db_links (from the schema owner) ...

should also help ...

-Sai Jeedigunta

Report message to a moderator

Re: Get all dblink names? [message #122899 is a reply to message #122101]

Thu, 09 June 2005 01:42

nabeelkhan
Messages: 73
Registered: May 2005
Location: Kuwait

Member

V$DBLINK: This view describes all database links (links with IN_TRANSACTION = YES) opened by the session issuing the query on V$DBLINK. These database links must be committed or rolled back before being closed.

ALL_DB_LINKS describes database links accessible to the user. This view does not display the PASSWORD column

DBA_DB_LINKS describes all database links in the database. Its columns are the same as those in "ALL_DB_LINKS".

USER_DB_LINKS describes database links owned by the current user. Its columns are the same as those in "ALL_DB_LINKS".

Report message to a moderator

Re: Get all dblink names? [message #123036 is a reply to message #122899]

Thu, 09 June 2005 10:59

alanm
Messages: 284
Registered: March 2005

Senior Member

hi use the following sql

PROMPT database links

col name form a40 wrap

SELECT owner,
db_link,
username,
host,
created
FROM sys.dba_db_links
ORDER BY 1;

cheers

Alan

Report message to a moderator

Previous Topic:	Database Hang?
Next Topic:	max extents

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 06:06:43 CST 2025