Oracle创建DBlink

创建dblink

CREATE PUBLIC DATABASE LINK dblink1 CONNECT TO username IDENTIFIED BY userpassword USING '(DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
     )
     (CONNECT_DATA =
    (SERVICE_NAME = orcl)
     )
   )' 

注意：如果密码存在大小写的话，需要用双引号括起来

create public database link dblink1 connect to db1 identified by "123*456" using 'db11'

删除dblink

 drop public database link dblink1;

查看dblink

select * from  all_db_links;
select * from user_db_links;

创建远程数据库同义

create synonym  for TABLENAME@DBLNKNAME; 

使用dblink

--查询  
select * from TABLENAME@DBLNKNAME;
--操纵远程数据库记录
insert into TABLENAME@DBLNKNAME (a,b)  values (va,vb);
update    TABLENAME@DBLNKNAME  set a='this';
delete from TABLENAME@DBLNKNAME;
--怎样执行远程的内嵌过程
begin
otherdbpro@to_html(参数);
end;