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

[larkim82]

下面是我创建同义词的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 ;

[小灰狼W]

这是因为用到了dblink 当通过dblink连接到远程数据库时，查询语句也会打开一个事务，所以需要提交

[CT_LXL]

引用 楼主 yanggang82 的回复:

下面是我创建同义词的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也是如此

[huangdh12]

dblink导致的。

[好记忆不如烂笔头abc]

引用 楼主 yanggang82 的回复:

下面是我创建同义词的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没关系。是PL/SQL没有一次查询列出所有的结果，点击绿色向下的箭头展开即可。