sql statement cause ora-01555
select count(*) from t_prd_info prd, t_prc_info prc, t_pth_data pth
where prc.prc_start between
(
select rng1 from
(select pth_date rng1 from t_pth_data
where pth_draw_no='12345'
and pth_line_id='1'
and pth_date < '29-NOV-11 16:08:44'
order by pth_date desc) range1
where rownum=1
)
and
(
select rng2 from
(select pth_date rng2 from t_pth_data
where pth_draw_no='12345'
and pth_line_id='1'
and pth_date > '29-NOV-11 16:08:44'