/*********************************************************
*PURPOSE: Query to list all DB Links in a database *
*AUTHOR: Shailender Thallam *
*********************************************************/
SELECT obj.object_type "Object Type",
obj.owner "Object Owner",
obj.object_name "Object Name",
obj.status "Object Status",
dbl.db_link "DB Link",
dbl.username "DB User Name",
dbl.host "DB Host"
FROM dba_objects obj,
dba_db_links dbl
WHERE obj.object_name = dbl.db_link
AND obj.object_type = 'DATABASE LINK'; |
/*********************************************************
*PURPOSE: Query to list all DB Links in a database *
*AUTHOR: Shailender Thallam *
*********************************************************/
SELECT obj.object_type "Object Type",
obj.owner "Object Owner",
obj.object_name "Object Name",
obj.status "Object Status",
dbl.db_link "DB Link",
dbl.username "DB User Name",
dbl.host "DB Host"
FROM dba_objects obj,
dba_db_links dbl
WHERE obj.object_name = dbl.db_link
AND obj.object_type = 'DATABASE LINK';