Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Table space not reclaimed after truncate

787588Mar 31 2012 — edited Mar 31 2012
Experts,

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2012
Added on Mar 31 2012
9 comments
17,421 views