Are either face_dataquality or message_archive tables changing (DML with COMMIT)
SELECT Count(request_id) AS MissingFaceRecords FROM face_dataquality WHERE face_dataquality.request_id IN (SELECT request_id FROM message_archive WHERE ( request_type = '1' AND return_value = '1' ) AND creation_datetime BETWEEN '11-JAN-13 12.00.00.00 AM' AND '11-JAN-13 220.127.116.11 PM') AND ( face_qual_score =- 2 )
978154 wrote:COMMIT inside LOOP is a direct cause of ORA-01555 error being reported by the SELECT
Yeah there is change i.e meanwhile DML is happening to the tables.
We have shell script which we 4 sql queries same as like posted..after getting output of 3 getting the snapshot to error for the 4th query(posted query).
Thanks & Regards