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!

Truncate Table not releasing space

3528418Dec 8 2017 — edited Dec 12 2017

Hi Team,

I have one table taking 40 GB space.

I truncated that table and also purge recycle bin.

Its now showing zero rows but still showing that its taking 40 GB in database.

My question is, Isn't truncate release table internally by itself?

If I wants to reclaim space immediately after truncate then what are possible ways?

Please let me know.

This post has been answered by BluShadow on Dec 8 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 9 2018
Added on Dec 8 2017
7 comments
5,668 views