checking for db_link
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: checking for db_link

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    hi

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

    thanks

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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

  3. #3
    Join Date
    Nov 2000
    Posts
    101
    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
  •  



Click Here to Expand Forum to Full Width