本文共 789 字，大约阅读时间需要 2 分钟。

Oracle?????????????

?Oracle?????????????Database Link??????????????????????????????????????????????????

1. ???????

??????????????SQL??????????????????SQL??????

create database link FistDBlink connection  connect to dbName identified by dbPassword  using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.4.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)));

?????

• ???dbName?dbPassword??????????
• ??????????????????????
• ????????????????

2. ???????

?????????????????????????????????

select * from db.tb_test@FistDBlink;

?????

3. ???????

?????????????????????????

drop database link FistDBlink;

???????

• ????????????????
• ???????????????????????

????????????????Oracle????????????????????????????????????????????