Oracle如何實現跨庫查詢？

網絡連通的情況下，可以使用DBLink

create database link db1 connect to 用戶名 identified by 密碼 using'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.111)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = 實例名) ) )'; -- 查詢的時候直接使用 select * from 用戶名.表名@db1;