How to delete data and free up disk space
879605Dec 25 2011 — edited Dec 26 2011Hi ,
I would like to know how usually one would delete data from an Oracle 10G which actually frees up disc space. Past scenario, we have had cases where clearing up 3 million rows of data does not translate to a decrement in disc space usage.
Scenario:
sqlplus > delete from AAA_CDR where date_created between today and the day before;
sqlplus > 2 million records deleted.
[root@Billing ~]# df -h (after issuing the delete above)
Results in no change to the disc space usage.
Which also brings me to the question, will one need to flush anymore tables in order for oracle to completely delete all the data that is supposedly deleted by the delete DML .
any help please ,