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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11366721/viewspace-692860/