ORACLE 11G DBLINK 上无法使用递归查询
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production上面dblink无法使用递归查询
下面的sql语句
select data_id, data_name, grade, DISORDER
from (select distinct a.*
from g_data_right a
start with a.data_id in (select data_id
from g_staff_data_right
where staff_id = '1001')
connect by prior a.parent_id = a.data_id) c
where c.parent_id = '1'
AND DATA_ID <> '99'
order by DISORDER
g_data_right，g_staff_data_right 是建立的public同义词都是访问远程库 ，报ORA-02016错误，
在oracle10g上执行没问题。
页:
[1]