Create a Database Link

最新推荐文章于 2025-08-15 10:38:51 发布

转载最新推荐文章于 2025-08-15 10:38:51 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/GoDevil/archive/2008/08/07/1262748.html

文章标签：

#数据库 #网络

本文介绍了一种在不同数据库实例间创建数据库链接的方法，例如在测试实例和生产实例之间，以便于数据比较和访问。通过创建数据库链接，可以从测试数据库访问生产数据，文中详细解释了创建过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

In many cases you might need to compare data between tables across different databases. For example your test instance and production instance.

You can easily create a database link between the 2 instances and be able to access the production data from the test database.

CREATE DATABASE LINK <Link Name>
CONNECT TO <Schema Name>
IDENTIFIED BY <PWD>
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Host Name>)(PORT = <port#>))
)
(CONNECT_DATA =
(SERVICE_NAME = <Database Name>)
)
)';