ORACLE DBLINK 使用

CREATE PUBLIC DATABASE LINK MYDBLINK
CONNECT TO RAMS IDENTIFIED BY RAMS
USING '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.2.252)(PORT = 1521)))(CONNECT_DATA =(SID = hrarelease)))';
drop public database link RAMS_XY;

select owner,object_name from dba_objects where object_type='DATABASE LINK';