oracle DB link使用
1、-- create database link
create database link ORCL.ABC.DEF
connect to USER1
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = 10.134.1.233) (PORT = 1521 ))
)
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)';
2、使用db link:
create or replace view xxxxxxx