查看 创建的dblink

select * from dba_db_links

创建 dblink

create public database link dblinkname connect to username identified by password

　　 using '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST =ip)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME =servicename)

)

)';

删除dblink

drop public database link dblinkname;