Table size growing, even after deleting records
Hi Experts,
We have a purge script the executes overnight to delete old data from tables. Every night the script deletes a huge number of records from tables. Even after that one of our tables growing heavily - I was expecting oracle to use the free space that been created due to delete. We are not using any direct load or /*+APPEND */ to populate this table.
Do you know any reason? How to control the growth of this table. Number of records deleted every day is more or less equal to number of records inserted into this table daily.
Regards,