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 truncated, but segments were not cleaned

Ratnesh SharmaOct 24 2013 — edited Oct 25 2013

Hi,

I am running oracle 11g 11.2.0.1.0 version on ASM.

I have truncated a 3.5 GB partitioned table, but the extents are not getting dropped and space is not getting released.

the table do not have any rows now, but the dba_extents and dba_segments are still showing 3.5 gb size.

Please suggest what could be the possible reason.

Please let me know if additional information is required to answer my qustion.

regards

This post has been answered by Hemant K Chitale on Oct 25 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 22 2013

Added on Oct 24 2013

#general-database-discussions

8 comments

2,599 views