Re: question about progress of shrink operation

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