Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2004
    Location
    Berlin, Germany
    Posts
    12

    Unanswered: multiple Database links

    Hello,

    I have two oracle machines (serv1 & serv2) , three schemas (schem1,schem2,schem3) and two databaselinks (dblink1, dblink2)
    dblink1 points from schem1 -> schem2
    dblink2 points from schem2 -> schem3

    and schem1 is on serv1
    schem2 and schem3 on serv2 (serv2 is a productivsystem only read)

    SELECT * FROM schem3.table@dblink2 works, but only on serv2 and i have to run it in schem1 on serv1

    How can i use the dblink2 in schem1?
    This is the second time this problem shows up and I don't won't this csv-Export/Import anymore. This should work with SQL.

    Ulf

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    make new dblink as below:
    dblink3 points from schem1 -> schem3
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    Location
    Berlin, Germany
    Posts
    12
    I can't, it's system user and i don't have the PW

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Make a synonym in schem1 so you can reference it.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I can't
    List what you CAN do so we can avoid more unworkable suggestions.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  6. #6
    Join Date
    Jun 2009
    Posts
    7
    dblink2 exists for schem2 on server2, so you can't use it in schem1 on Serv1.

    You can use dblink1 by giving Read only access to schem2 on schme3.

  7. #7
    Join Date
    Aug 2004
    Location
    Berlin, Germany
    Posts
    12
    OK,
    how can i do this?

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    On server2 create a SYNONYM or VIEW which includes the dblink2, such that it can be accessed from server1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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