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!

Alter table modify lob shrink space

Rosh_dbaJun 5 2018 — edited Jun 5 2018

I have a 12.1.0.2 version of Oracle database with a table of 30Tb - non partitioned and having a BLOB column

In order to reclaim space after mass purging of rows, I want to use the following command instead of online redefinition

Alter table table_name modify lob ( lob_column) shrink space

Since it is a production database, can somebody please confirm that this can be done online with no performance hit ? There will be multiple DML's running on the table

Are there any other things which I need to consider ?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2018

Added on Jun 5 2018

#general-database-discussions

8 comments

5,234 views