Database Administration (MOSC)

MOSC Banner

sql statement cause ora-01555

edited Mar 14, 2012 2:55AM in Database Administration (MOSC) 8 commentsAnswered
In the alert log it showed the following sql select query caused 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'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center