Oracle·DB LINK 链接到另一个数据库

CREATE DATABASE LINK dblinkname CONNECT TO dbuser IDENTIFIED BY your_password USING 'orcl';

CREATE PUBLIC DATABASE LINK 数据链名称 CONNECT TO 登陆用户名 IDENTIFIED BY 密码 USING '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 对方Oracle服务器的IP地址)(PORT = 端口号)) ) (CONNECT_DATA =(SERVICE_NAME = 对方Oracle服务器服务名) ))'	

select owner, db_link from dba_db_links;

select * from user_db_links;	

drop database link 数据链名称;	

CREATE DATABASE LINK WEB 
CONNECT TO WEB IDENTIFIED BY 0CfJly7y5YB060Cf5YBCf 
USING 'orcl';

CREATE VIEW ACCOUNT AS SELECT username, password FROM member@WEB;

select * from ACCOUNT where username="netkiller";