Thread: Vacuum full issue
Hi All,
One of my friend project they did vacuum full last week since one of the table column data type were CLOB after that activity the dev team found out some of the data were missing or corrupt (XML) , please explain me will vacuum full have any limitation like that?
Thanks
Ramakrishnan
On Thu, Feb 16, 2023 at 12:24 PM Rama Krishnan <raghuldrag@gmail.com> wrote:
One of my friend project they did vacuum full last week since one of the table column data type were CLOB after that activity the dev team found out some of the data were missing or corrupt (XML) , please explain me will vacuum full have any limitation like that?
No, vacuum full is not designed to destroy xml data that has been stored in the database.
David J.
On 2/16/23 05:18, Rama Krishnan wrote: > Hi All, > > One of my friend project they did vacuum full last week since one of > the table column data type were CLOB after that activity the dev team > found out some of the data were missing or corrupt (XML) , please > explain me will vacuum full have any limitation like that? I'm guessing this has to do with whatever condition caused then to decide to do VACUUM FULL in the first place. Why did they do the VACUUM FULL? > > Thanks > Ramakrishnan -- Adrian Klaver adrian.klaver@aklaver.com