Hi Stecal,

Thanks for the reply.

I totally agree with you in terms of how 01555 occurs.

Table A has 150 Mil rows.

In my scenario, one query with 10 connections (using informatica level partitioning using MOD and ROW_NUM) selecting the data from table A and inserting in table B and committing for 100000 records (again this is also informatica level configurable parameter).

I got 01555 on table A.

I am sure that no other process is doing any DML on table A when my job is running.

Could you please explain me what are the possible scenarios to get 01555 in this case?

Thanks,