How to check dblink in oracle?

1.0K    Asked by AdityaYadav in SQL Server , Asked on Oct 3, 2022

The title says it all, is there a way to quickly list all the current database links in oracle?


Something along the same lines as this, which lists the current user's tables:


select * from user_tables;
Answered by Aishwarya Jhadav

The answer to your question - how to check dblink in oracle is -


  SELECT DB_LINK, USERNAME, HOST FROM ALL_DB_LINKS

you can try that, perhaps it can help you solve your problem



Your Answer

Interviews

Parent Categories