创建公共DBLink
<ul>
<li>创建公共DBlink</li>
</ul>
<pre><code>create public database link bisdb connect to 账号 identified by 密码 using 'NVTWIPDB.nvtpower.com';</code></pre>
<ul>
<li>在如下路径添加
<code>/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/tnsnames.ora</code></li>
</ul>
<pre><code>NVTWIPDB.nvtpower.com =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP或者计算机名)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = nvtwipdb)
)
)</code></pre>
<ul>
<li>执行创建</li>
</ul>
<pre><code>create public database link testwip connect to 账号 identified by 密码 using 'NVTWIPDB.nvtpower.com';</code></pre>
<ul>
<li>测试是否成功</li>
</ul>
<pre><code>SQL> select * from messys17h@testwip where enmkey in('DD1','101');</code></pre>
<ul>
<li>查看DBLink、删除DBLink</li>
</ul>
<pre><code>select * from dba_db_links;
--public可选
drop public database link BISDB;</code></pre>
<ul>
<li>详细的连接字符串</li>
</ul>
<pre><code>create public database link bisdb connect to 账号 identified by 密码 using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = nvtdb02)
))';</code></pre>