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

???????????

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

1. ?????????????

1.1 ??????????????

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

CREATE PUBLIC DATABASE LINK DATASOURCE-- @DESCRIPTION = (ADDRESS_LIST = --     (ADDRESS = (PROTOCOL = TCP)(HOST = sales.company.com)(PORT = 1521))--     (CONNECT_DATA = --         (SERVICE_NAME = sales)--     ));

1.2 ????????????

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

DROP PUBLIC DATABASE LINK DATASOURCE;

2. ??synonym????????

synonym??????Oracle??????????????????????????????

2.1 ??synonym?????

?????synonym??????????

CREATE SYNONYM GREENDRNFACREINS FOR table_name@DATASOURCE-- @DESCRIPTION = (ADDRESS_LIST = --     (ADDRESS = (PROTOCOL = TCP)(HOST = sales.company.com)(PORT = 1521))--     (CONNECT_DATA = --         (SERVICE_NAME = sales)--     ));

?????????????synonym?

CREATE SYNONYM GREENDRNFACREINS FOR cnprod.table_name

2.2 ??synonym???

?????synonym??????????

DROP SYNONYM GREENDRNFACREINS;

3. ???????????

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

SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME='GREENDRNFACREINS';

4. ?????????

• ???????????????????????????????????
• synonym?????synonym????????????????????????
• ???????????????????????????

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