checking for db_link

[ohgie]

hi

what's statement i use to check for database link
that i create

thanks

[sreddy]

Say you have a link "xyz" created to access a remote database table "abc.table_1". Check link state whether active or not by selecting some data from that remote database table using the link you have created.

SQL> SELECT * FROM abc.table_1@xyz ;


You will be getting the results if your link is active, otherwise troubleshoot the link depending upon errors you get.

[gandhi]

Hi,

Check the view
select * from user_db_links;


bye
gandhi