DB link使用步骤
--1.设置global_names=false--
alter system set global_names=false
--2.创建DB link---
create PUBLIC database link bjlink
CONNECT TO username IDENTIFIED BY password
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)'
---3.删除DB link--
DROP PUBLIC DATABASE LINK bj_link
--4.查找DB link--
select owner,object_name from dba_objects where object_type='DATABASE LINK'
--使用方法--
select * from tablename@linkname where f_order_num=?
--创建同义词--
create synonym 同义词名称
for 表名
--1.设置global_names=false--
alter system set global_names=false
--2.创建DB link---
create PUBLIC database link bjlink
CONNECT TO username IDENTIFIED BY password
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)'
---3.删除DB link--
DROP PUBLIC DATABASE LINK bj_link
--4.查找DB link--
select owner,object_name from dba_objects where object_type='DATABASE LINK'
--使用方法--
select * from tablename@linkname where f_order_num=?
--创建同义词--
create synonym 同义词名称
for 表名