Hi run vacuum only not full vaccum. And create a table using this existing table, partition it and then rename it to original table.
On Wed, 8 May, 2024, 2:48 pm Sunil Jadhav, <sunilbjpatil@xxxxxxxxx> wrote:
Hello team,We have a 12TB db and one table having around 7 TB data , is there any option we can removed the dead tuple and size also increase for that partition without downtime .Vaccum full we can't do because ofexclusive lock in tables during processing.We have critical application so don't get the downtown so how to achieve this please let us knowThank youSunil
