2 Replies Latest reply: Nov 20, 2012 2:44 AM by 928200 RSS

    DBLINK issue

    928200
      Hi Friends,

      I am facing an issue creating DBLINK.

      Let me explain the scenario.

      I have 2 databases on 2 different machines

      Source Machine1 :
      dbname:db001
      schemas: ABC ,XYZ
      Tables : A from ABC,X from XYZ

      Target Machine 2:
      Dbname:db002
      schema :PQR
      Table :P

      For loading data into P table(interface) require A from ABC,X from xyz.
      I require 2 dblinks are PQR-ABC,PQR-XYZ.
      my problem is when i am creating dlinks using ODI it is creating only 1 dblink with name db001.
      How to overcome this situation

      I need 2 dblinks
      PQR-ABC
      PQR-XYZ

      Regards,
      Srinivas
        • 1. Re: DBLINK issue
          Sutirtha Roy
          925197 wrote:
          Hi Friends,

          I am facing an issue creating DBLINK.

          Let me explain the scenario.

          I have 2 databases on 2 different machines

          Source Machine1 :
          dbname:db001
          schemas: ABC ,XYZ
          Tables : A from ABC,X from XYZ

          Target Machine 2:
          Dbname:db002
          schema :PQR
          Table :P

          For loading data into P table(interface) require A from ABC,X from xyz.
          I require 2 dblinks are PQR-ABC,PQR-XYZ.
          my problem is when i am creating dlinks using ODI it is creating only 1 dblink with name db001.
          How to overcome this situation
          Create 2 dataserver for db001. One for schema ABC ,another for schema XYZ
          Specify the dblink name in dataserver.

          I need 2 dblinks
          PQR-ABC
          PQR-XYZ

          Regards,
          Srinivas
          • 2. Re: DBLINK issue
            928200
            I have created 2 data servers 1 for ABC,1 for XY but we have one instance name that is db001 to 2 dataservers