个人简介
偶尔有空上来看看
文章分类
文章存档
最近访客
相关博文
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
- ·
分类： oracle
2011-03-23 09:52:06
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( )
-- *
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)
使用的同义词通过数据库链 指向另一个库的表
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( );
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( );
不再报错，原因待查
给主人留下些什么吧！~~