Oracle Database Link Practical

CREATE DATABASE LINK appstst1 CONNECT TO newasymodel IDENTIFIED BY secl2015 using
' (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.224)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
';

CREATE DATABASE LINK test2 CONNECT TO dblnk IDENTIFIED BY dblnk123 using
'(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.133)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )';
 
  Select * from ap_test@ test2;  
select * from sad_gen@ appstst1;
Select * from all_db_link;
drop DATABASE LINK appstst3;