直接登陆plsqldev.exe,然后选dblink,就可以看到所有的dblink了,右键可以修改和删除。
sql创建过程:
*************SQL COMMAND中*****************
create public database link get_db_link connect to aaa identified by aaa using 'get_link';
***********tnsnames.ora 中:***********
get_link=
(description=
(address=(protocol=tcp)
(host=192.168.131.75)
(port=1521))
(connect_data=
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)