dblink的简单使用
// 删除
drop public database link linkName ;
–创建DBLINK
create PUBLIC database link linkName
CONNECT TO username IDENTIFIED BY password
using
‘(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 端口号)) )
(CONNECT_DATA = (SERVICE_NAME = 数据库实例名) ) )’
–使用
create table t_test as select * from t_test@linkName ;