Simple PL/SQL linked remote Oracle database method

2. First locate the Tnsnames.ora file in D:\oracle\product\10.2.0\client_1\NETWORK\ADMIN under the Oracle installation directory

3.  

   Open tnsnames.ora 

   Add database you want to link

   Example 226 =  ( DESCRIPTION =    (address_list =      (ADDRESS = (PROTOCOL = TCP) (HOST = 10.10.124.226) (PORT = 1521)    )     (Connect_data =      ( service_name = ORCL)    )  

    

4.  

   Note: 226 for the database you are linked to the name of any name can       the rest of the address and port number and service_name just follow the database configuration you want to link 226 ( First name) do not have a space

   After saving in the open plsql drop-down list there will be a previously configured name (226)

5.  

   After writing the account and password can be linked, the account and password are not case-sensitive

   If you want to see only the tables of your project, and so on, select my objects

    

Simple PL/SQL linked remote Oracle database method