Purge data for tables deleteing in batches of 99999
Hi Team,
We have a weekly purge job(Public one) Which is deleting data in batch wise. Each one consists of 99999.
We want to understand is there any limit as we are not deleting all at once.
Any possibility to delete all at once on a particular table Ex:ORDER_RELEASE_STATUS has 15 lakhs records and it is deleted by 15 batches.
Regards
BhanuPrakash
0