ORA-01555 caused by SQL statement
hi,
I am facing this error in my Alert log file repeatedly with the following sql statement. please let me know what this error is and what are its impact on the system? and what are its work around?
ORA-01555 caused by SQL statement below (SQL ID: 1h6v8yvjqgpzt, Query Duration=0 sec, SCN: 0x0000.4d4a46c8):
Fri Mar 18 00:32:54 2011
select 'FR-'||lpad(Requz_no,7,0)||' '|| substr(MRNO,1,2)||'-'|| substr(MRNO,3,2)||'-'|| substr(MRNO,5,2)||' '|| decode(Prev_bls_grp, 'A+','A (Positive)', 'B+','B (Positive)', 'AB+','AB(Positive)', 'O+','O (Positive)', 'A-','A (Negative)', 'B-','B (Negative)', 'AB-','AB(Negative)', 'O-','O (Negative)', 'Unknown ')||' '|| to_char(Requz_date,'dd-mm-yyyy hh24:MI'), to_char(requz_no) from bld_requz_mstr where receive_by is null order by requz_no desc
I am facing this error in my Alert log file repeatedly with the following sql statement. please let me know what this error is and what are its impact on the system? and what are its work around?
ORA-01555 caused by SQL statement below (SQL ID: 1h6v8yvjqgpzt, Query Duration=0 sec, SCN: 0x0000.4d4a46c8):
Fri Mar 18 00:32:54 2011
select 'FR-'||lpad(Requz_no,7,0)||' '|| substr(MRNO,1,2)||'-'|| substr(MRNO,3,2)||'-'|| substr(MRNO,5,2)||' '|| decode(Prev_bls_grp, 'A+','A (Positive)', 'B+','B (Positive)', 'AB+','AB(Positive)', 'O+','O (Positive)', 'A-','A (Negative)', 'B-','B (Negative)', 'AB-','AB(Negative)', 'O-','O (Negative)', 'Unknown ')||' '|| to_char(Requz_date,'dd-mm-yyyy hh24:MI'), to_char(requz_no) from bld_requz_mstr where receive_by is null order by requz_no desc
0