1.10g 到11g的DBLINK
create database link orcl_36
connect to firstods identified by "zztabc"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.41.100.36)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
select * from dual@orcl_36