I am working on a Production System. And I have to do some database cleaning work on daily basis.
I am deleting 5 Lacks Records from a table on daily basis, But whenever I am deleting records and checking the tablespace, there is no improvement in the free space. It is as it is.
How space of the tablespace will be increasing even deleting rows also.
Yours responce in this regard is appreciated...