语句，或可通过可视化操作

-- Create database link 

create database link DBL_TEST

connect to UID identified by PSW

using '(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XX.XX)(PORT = XXXX))

(CONNECT_DATA =

(SERVER = XXX)

(SERVICE_NAME = XX)

)

)';

 

在建了该  DB_LINK 的 用户下  执行表操作如：select * from sys_table@DBL_TEST   即可