database link sequence ,synonym

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-692859/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/11366721/viewspace-692859/