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@xxxxxxxxx> 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@xxxxxxxxx>
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.