fitzj...@cox.net schrieb:
On Nov 14, 10:33 am, newhorizon <mehmete...@gmail.com> wrote:
I am glad put the command for the rman backup.
I really appreciate the comments on adding the achivelog in the
backupset.
What are your thoughts about shrinking the tables before the backup ?
I can't see that such an act would benefit you in terms of the backup
size. A shrink will only take away unused space (that above the HWM),
not free space located below the high water mark, so you might save a
few blocks of space per table, but it likely won't be appreciable.
I can't recommend it, but others may have differing opinions.
David Fitzjarrell
I agree with your recommendation, however, if you refer to shrink in
sense of "ALTER TABLE ... SHRINK ...", then it does free space below HWM . Best regards
Maxim
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 104:31:22 |
Calls: | 6,660 |
Calls today: | 2 |
Files: | 12,209 |
Messages: | 5,335,176 |