DB Link

create database link DBLink名 connect to 用户 identified by 密码 using 'TNS';
create database link orcl_19c connect to orcl_link identified by bpxtest using 'orcl'; --配置tnsname.ora
create database link orcl_19 connect to orcl_link identified by bpxtest using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))';


select owner, db_link, username from dba_db_links;