ORA-02070:数据库在这种情况下不支持 [英] ORA-02070: database does not support in this context

问题描述

我有一个类似

INSERT INTO sid_rem@dev_db
(sid)
select sid from v$session

现在，当我执行此查询时，我得到 ORA-02070: database does not support in this context

Now, when i execute this query i get ORA-02070: database does not support in this context

仅当我将v $ session中的数据插入某个远程数据库时，才会发生此错误.对于其他任何表，它都可以正常工作.

This error happens only when I insert data from v$session into some remote db. Its working fine for any other table.

任何人都知道为什么这个问题以及解决方法吗?

Anyone know why this issue and any workaround for this?

推荐答案

使用gv$session而不是v$session进行工作:

INSERT INTO sid_rem@dev_db(sid)
select sid from gv$session;

gv $视图是全局视图，也就是说，它们不限于一个节点(实例)，而是查看整个数据库(RAC). v $视图是gv $的子视图.

gv$ views are global views, that is, they are not restricted to one node(instance), but see the entire database(RAC). v$ views are subviews of gv$.

在互联网上搜索时，我发现这与分布式交易有关.

Searching on the internet I found this has something to do with distributed transactions.

ora-code.com上的线程

这篇关于ORA-02070:数据库在这种情况下不支持的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！