Dblink

• 创建远程连接

  CREATE PUBLIC DATABASE LINK dblink_name CONNECT TO pets IDENDIFIED BY pets USING '12.99.83.44:1521/orcl';
  

• 校验远程链接是否成功

  SELECT * FROM DUAL@dblink_name;
  

• 查看数据库中有哪些Dblink

  SELECT * FROM DBA_DB_LINKS;