I would like to know how usually one would delete data from an Oracle 9i DBMS which actually frees up disc space. Past scenario, we have had cases where clearing up 1-2 million rows of data does not translate to a decrement in disc space usage.
sqlplus > delete from audit_log where date_created between today and the day before; sqlplus > 2 million records deleted. bash$: du -sh (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