Hello,
Let's say that I have a tablespace T. I now clean up by deleting a number
of big tables in the tablespace, e.g. bringing it down from 4 TiB to 2 TiB of used pages.
I'm hoping that the deletion of the tables will also translate to a
quicker online backup of T. But for that to happen: Is it required to run
an "ALTER TABLESPACE t REDUCE MAX" before I will see quicker backups? -
Or is the backup procedure clever enough to skip unused pages? Is there a difference between full, incremental or delta backups in this regard?
--
Regards,
Troels Arvin
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 286 |
Nodes: | 16 (2 / 14) |
Uptime: | 83:59:06 |
Calls: | 6,495 |
Calls today: | 6 |
Files: | 12,097 |
Messages: | 5,276,894 |