How to reduce the table size for any table while using truncate or delete statements. In oracle 8i it was truncating the storage space but in 10g it is not ....

I have given truncate statement in a procedure to drop the storage of a table used... when its record count exceeds 500.

[code=oracle]
BEGIN

i:= 0;

FOR CC IN NLD LOOP

DELETE FROM CHN_BED5A_T4_FX ;

COMMIT;...