ITPub博客

首页 > Linux操作系统 > Linux操作系统 > database link sequence ,synonym

database link sequence ,synonym

原创 Linux操作系统 作者:ganwangge 时间:2011-04-19 16:04:15 0 删除 编辑

create database link  mes1_likseq_wfl40 connect to wfl identified by wfldata using 'SGERPDB'
select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;
select * from mes1_lik_wfl40.wfs_tb_fcsmail
select * from mes1_lik_wfl40.wfs_tb_fcsmail
select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;
select * from mes1_lik_wfl40.wfs_tb_fcsmail
select seq_wfs_tb_fcsmail.nextval@mes1_likseq_wfl40 from dual;

 

create database link  mes1_lik_wfl40 connect to wfl identified by wfldata using 'SGERPDB'
select * from wfs_tb_fcsmail@mes1_lik_wfl40
select * from seq_wfs_tb_fcsmail@mes1_lik_wfl40
select seq_wfs_tb_fcsmail.nextval@mes1_lik_wfl40 from dual;
create view  wfs_tb_fcsmail as select * from wfs_tb_fcsmail@mes1_lik_wfl40
grant select on wfs_tb_fcsmail to mes1
grant insert on wfs_tb_fcsmail to mes1
create synonym seq_wfs_tb_fcsmail for  seq_wfs_tb_fcsmail@mes1_lik_wfl40
select seq_wfs_tb_fcsmail.nextval from dual;
grant select on seq_wfs_tb_fcsmail@mes1_lik_wfl40  to mes1

SQL> grant create view to mes1_lik_wfl40;

Grant succeeded.

SQL> grant create synonym to mes1_lik_wfl40;

Grant succeeded.

SQL>

SQL> grant create database link to  mes1_lik_wfl40;

Grant succeeded.

 

SQL> grant create database link to  mes1_lik_wfl40;

Grant succeeded.

 


 

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11366721/viewspace-692860/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-03-30

  • 博文量
    22
  • 访问量
    6124