那就是: oracle不支持分布式数据库的 insert ... select ...@dblink
呵呵
在文档中有说明,oracle支持也确认了的
--------------------------------------
不知道你的情况是不是跟这个有差异
INSERT A LOCAL TABLE SELECT * FROM TABLE@DBLINK
INSERT A LOCAL TABLE@DBLINK SELECT * FROM TABLE
不知道这两个是不是有本质的差异
stargwjf% oerr ora 2064
02064, 00000, "distributed operation not supported"
// *Cause: One of the following unsupported operations was attempted:
// 1. array execute of a remote update with a subquery that references
// a dblink, or
// 2. an update of a long column with bind variable and an update of
// a second column with a subquery that both references a dblink
// and a bind variable, or
// 3. a commit is issued in a coordinated session from an RPC with
// OUT parameters.
// *Action: simplify remote update statement