Re: lob segment

Posted by ErmanArslansOracleBlog on Dec 13, 2022; 5:14am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/lob-segment-tp11349p11361.html

Please go thorugh that MOS note Roshan . How to Shrink a Securefile LOB Using Online Redefinition (DBMS_REDEFINITION)? (Doc ID 1394613.1).. REad it carefully and you ll understand.. You create an interim table and then do the redef.. A new lob with a smaller size appears at the end.

Test it on your test environment and examine the storage needs there. The needed storage space is defined as : there should be a sufficient disk space available to hold both the 'unshrunk' table as well as the 'shrunk' table.