-
hi
what's statement i use to check for database link
that i create
thanks
-
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.
Reddy,Sam
-
Hi,
Check the view
select * from user_db_links;
bye
gandhi
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|