1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Public and private database link.

Discussion in 'General' started by kalenko, May 9, 2018.

Tags:
  1. kalenko

    kalenko Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Vietnam
    Hi,

    I have two database links, one public and one private, which have the same name SVBO and connect to the same remote database using the same remote user. Then I issue the following statement:

    select sysdate from dual@svbo;

    Please tell me the result is returned by public database link or private database link?
    Thanks.
     
    Last edited: May 9, 2018
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,639
    Likes Received:
    368
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Who owns the private database link? Only that user can access the private link; all others use the public link.
     
  3. kalenko

    kalenko Active Member

    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Vietnam
    The user who issue the query statement is the owner of both database links.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,639
    Likes Received:
    368
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Why does the same user have BOTH public and private database links? That makes no sense. The owner will always use the private link and since the both links are the same it would be better to have ONE public link.