Results 1 to 4 of 4

Thread: DB link

  1. #1
    Join Date
    Sep 2009
    Location
    Serbia
    Posts
    17

    Unanswered: DB link

    Hi guys!
    Is it posible to create one dblink to another db, and then use it to connect on 2 diffrent remote users?
    Please if you can answer me ASAP...

    Thanks!

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Whilst waiting for others to reply ASAP I assume that you tried this yourself - did you get an answer?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Sep 2009
    Location
    Serbia
    Posts
    17
    I get this on Oracle :

    It is better to use private database links.
    It is better for database links to point to a dedicated schema (not a table owner), then you can selectively grant to that user from multiple table-owner schemas, and create synonyms for the necessary objects.


    But to be honest i dont get it ....

    I dont know how this solve my problem because i already have public link on target db, and i need to include another user so that i can conect from one database to other with connection on two users....
    Last edited by prepek2000; 11-20-09 at 08:02.

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Your first post said:

    Is it posible to create one dblink to another db, and then use it to connect on 2 diffrent remote users?
    TBH I don't know the answer off the top of my head, and I haven't got time at the moment to look into this for you, but have you TRIED to create one link & then used it to connect with 2 different users? If so, did you get an error message telling you it couldn't be done? Or did it work? (in other words, if you try this yourself you may get a quicker response than waiting for someone else to do it for you)
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •