Oracle Database Discussions

Hi All,

Database version 10.2.0.2

Delete command is not deleting all rows and deleting some subset of rows which it should delete, ever time I delete and do the roll back, next time it will delete some random rows, count is different everytime with in the range but not complete in anyway. see the following -

select count(*) from test where evt_id in (select evt_id from test1);
COUNT(*)
----------
27105


delete from test where evt_id in (select evt_id from test1);

16045 rows deleted.

select count(*) from test where evt_id in (select evt_id from test1);

11060


rollback;


Againg the same procedure -
-------------------------------------

select count(*) from test where evt_id in (select evt_id from test1);
COUNT(*)
----------
27105


delete from test where evt_id in (select evt_id from test1);

14320 rows deleted.

select count(*) from test where evt_id in (select evt_id from test1);

COUNT(*)
----------
12785



why its not deleting all the 27k rows in one shot? Is there any bug related to that?


Thanks
Abhinav