PL/SQL中查询同义词，为何打开了需要提交_Oracle管理

PL/SQL中查询同义词，为什么打开了需要提交

本帖最后由 yanggang82 于 2014-06-30 13:58:53 编辑

下面是我创建同义词的sql
1.创建dblink
create public database link remote_link connect to user identified by pass using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 12.23.34.45)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

2.创建同义词
create synonym remote_class for class@remote_link ;
------解决方案--------------------

引用:

下面是我创建同义词的sql
1.创建dblink
create public database link remote_link connect to user identified by pass using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 12.23.34.45)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';

2.创建同义词
create synonym remote_class for class@remote_link ;

当你用进行DBlink操作数据库时，远程的数据库并不能识别远程的请求是否是一个DML还是普通的查询，所以每个连接都会新建一个Session,即使是select也是如此