创建数据库链接

**********创建数据库链接******************
CREATE DATABASE LINK "名称"
CONNECT TO "用户名" IDENTIFIED BY VALUES '密码'
USING '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DB2数据库服务名)
)
)'
***********从A库取db_one库的数据
select * from test@db_one;

test表是db_one库中的一个表，sql在A库中查找