18May/100
Oracle: List all database-links
To list all db-links (must be a user with permission to select from sys.dba_db_links) in a database:
SELECT * FROM DBA_DB_LINKS;
Sample output:
1 2 3 4 5 6 | SQL> SELECT * FROM DBA_DB_LINKS; OWNER DB_LINK USERNAME HOST CREATED ------- ---------- ---------- ------- ---------- SYSTEM TEST_LINK SCOTT TST11 26-SEP-08 SCOTT HR_LINK HR TST11 26-SEP-08 |
Related posts: