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 will delete the corresponding LOB segment of table or not ?

906790Sep 11 2012 — edited Sep 11 2012
Hi All,

I have few table with LOB segments, if i fire the truncate table on those table will it purge the LOB segment as well ?

Approximately how much time will take to truncate 100gb LOB segments.

Thanks
This post has been answered by Pierre Forstmann on Sep 11 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 9 2012
Added on Sep 11 2012
3 comments
10,506 views