Table space not reclaimed after truncate
787588Mar 31 2012 — edited Mar 31 2012Experts,
Database version: 11.1.0.7
I have a table size of 8 GB, Where i have to truncate the table.
I used "Truncate table <table_name> reuse storage" , But when i check by query to find out tablespace which is reclaimable, It showing same as before.
Even tried with DBMS_SPACE_ADMIN.drop_empty_segments , But no Luck.
Any thoughts on this please?