创建dblink

CREATE PUBLIC DATABASE LINK dblink1 CONNECT TO **username** IDENTIFIED BY **userpassword** USING '(DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     )
     (CONNECT_DATA =
    (SERVICE_NAME = orcl)
     )
   )'

删除dblink

 drop public database link dblink1;