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!

Copy Tables with Lob Segment decrease space at 20%

SpugnaDec 13 2019 — edited Dec 15 2019

I have a table with a lob segments (about 250Gb) (Enterprise edition 12c)

I create a new partitioned empty table than I used the statement:

insert /* append parallel(4) */ into new_tableĀ  select * from old_table

The new table size is less than 50Gb.

I checked the number of row and it matches.

How it's possible? Fragmentation?

And if It's Fragmentation, how can I know, in advance, how much space an operation like this can save?

I mean some query that I can run against the old table for check space that can be released.

Thanks in advance.

Comments
Post Details
Added on Dec 13 2019
3 comments
469 views