关闭 oracle dblink 功能

alter system set open_links=0 sid ='*' scope=spfile;

System altered.

alter system set open_links_per_instance=0 sid ='*' scope=spfile;

System altered.


重启数据库


SELECT id FROM tb@db_link  where rownum<=10
                                   *
ERROR at line 1:
ORA-02020: too many database links in use