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 command

415008Jul 25 2004 — edited Jun 13 2005
According to my information truncate command by default will release all the allocated space for the truncated table and delete its contains as well ,that means it will deallocate all it's extents .But with truncate table_name reuse ,it will delete all the data in this table but it will not release it's extents ,they can by used again by this table .My question is when I queried dba_segment view for this table in both cases it return some extents still allocated even after truncate table_name drop command .

Can someone clear it up for me?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2005
Added on Jul 25 2004
6 comments
294 views