Re: question about progress of shrink operation

Apologies I missed these details: so is about a big non-partitioned table (around 5TB - table + 3 CLOBS). The version is 19.20. Plan is to shrink each clob individually then run shrink at table level. Is kind of hard to estimate the undo requirements and the first trial failed due to lack of UNDO space after a few days of running .

În vin., 26 ian. 2024 la 11:31, Jonathan Lewis <jlewisoracle_at_gmail.com> a scris:

> It would be a good idea to specify which version(s) of Oracle you want to
> do this on (and whether the tables are (composite) partitioned) ; it's
> possible that the correct answer for a newer version of Oracle is wrong for
> an older version. I have a few notes about ridiculous problems with the
> shrink space command for LOBs (on "very old" versions) so I'd test every
> time I needed to try it on a newer version.
>
>
> Regards
> Jonathan Lewis
>
>
> On Fri, 26 Jan 2024 at 08:42, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
> wrote:
>
>> Dear all,
>>
>> What will happen with progress of a shrink operation of a CLOB if it
>> fails due to various reasons like for example undo space. Will it be all
>> lost or partially lost or no lost progress?
>>
>> THank you.
>>
>

--
http://www.freelists.org/webpage/oracle-l