Saturday, January 2, 2016

How to find DB links in Oracle??

select * from DBA_DB_LINKS   - All DB links defined in the database.
select * from ALL_DB_LINKS    - All DB links the current user has access to.
select * from USER_DB_LINKS - All DB links owned by current user.

No comments: