Re: question about progress of shrink operation

THank you for your answers.

It is: STORE AS BASICAFILE, ENABLE STORAGE IN ROW CHUNK 8192 NOCACHE

Indeed I observe the operation itself will start a transaction the moment the command is executed and subsequently there are a very large number of small transactions done.

It seems like the progress is not lost based on tests, but I haven`t found this aspect properly documented.

În sâm., 27 ian. 2024 la 20:43, Jonathan Lewis <jlewisoracle_at_gmail.com> a scris:

> A question I forgot to ask - are your LOBs securefile or basicfile, and
> what are your logging, caching, and "storage in row" settings. Again, it
> might make a difference.
> 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