同义词执行语句报错ora-02063 ora-01008 ora-12801

oracle 10.2.0.3 on aix 64 bit

执行语句

select 
-- *
count(0) cnt
  from f_syn a, v_syn b
 where a.lrsj between to_date('20110321 01', 'yyyymmdd hh24') and
       to_date('20110321 23', 'yyyymmdd hh24')
   and a.JCSBBH IN ('C021', 'H002', 'C024',
        'D804', 'H001', 'C022',
        'C025', 'C026', 'C027')
   and a.clbz = '0'
   and a.id = b.xh(+)

 

报错：
ORA-12801: error signaled in parallel query server P005, instance dbsvr1:orcl1 (1)
ORA-01008: not all variables bound
ORA-02063: 紧接着 2 lines (起自 DBLINK_36)
使用的同义词通过数据库链 指向另一个库的表

 

改写
select 
-- *
count(0) cnt
  from a, b
 where a.lrsj between to_date('20110321 01', 'yyyymmdd hh24') and
       to_date('20110321 23', 'yyyymmdd hh24')
   and a.JCSBBH IN ('C021', 'H002', 'C024',
        'D804', 'D001', 'C022',
        'C025', 'C026', 'C027')
   and a.clbz = '0'
   and a.id = b.xh(+);

不再报错，原因待查