2 Replies Latest reply: Jun 3, 2013 5:25 AM by 963974 RSS

    creating db link between two databases.


      I want to generate a query from two tables on two different databases on same server. For that i am trying to create a db link.

      for eg: i have table 1 in oracle people soft database and table 2 in hra database and i want to make a relation. so i want to generate a query from these two tables.

      i found the syntax for creating db link as

      create public database link
      connect to
      identified by
      using 'tns_service_name';

      I am using toad interface to connect to both these databases. if i have to create the db link, how should i proceed and where should i write the above syntax (in which database)?

      Any inputs would be highly appreciated.