I have big database which contains a table of 2.7TB of data. I deleted some records, and I want to reclaim the disk space.
However, i only have about 200 gb free disk space left. How can I do this? The physical files of the 2.7 TB file are all splitted in 1 gb files.
For the vacuum full, will I need 2.7 TB of free disk space or 1 gb ? How will I ever be able to run the full vacuum? I read something about the symbolic link to an other server drive but i'm not sure an other server has 3 TB of storage left.
Can anyone help me out? Thanks!