what's statement i use to check for database link
that i create
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.
Check the view
select * from user_db_links;
Click Here to Expand Forum to Full Width