but to do what you want as i think you need to create procedure , in the code you will use the above view to check the database link and inserted information in another table with date .
Select * from v$dblink
974884 wrote:No scripts please. Use PL/SQL properly. Stored in the database.
We have a need to write a script to validate the DB links in each database.
I am stuck with, how to validate the private DB links.It can only be validated when executing code as the schema that owns the database link.