database link question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: database link question

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    database link question

    Hi

    if i have 2 schemas in database1(globalname : db1.oracle.com)
    User1 & user2

    & there is another schema in database2(globalname : db2.oracle.com)
    testuser


    I am pulling data from database1(user1 & user2) to database2 (testuser)
    so i am using database links

    ideally database link naming convention mandates that we have the global name of the
    database we want to connect to as the name of the database link

    so in my case in database2 - testuser schema i create link like this
    link name - db1.oracle.com connect to user1 identified by --- using '---'

    it works fine

    now i want a link to user2 schema in database 1
    What name should i use for the link . i cant use db1.oracle.com as it is
    already pointing to user1 schema


    Kindly respond

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Why do u wana create another db link, when you have one..cant u select data of user2 from user1? if not give select privis on the table of user2 to user1 on db1.

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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