On Wednesday, November 14, 2007 at 1:20:21 PM UTC-8, Maxim Demenko wrote:
[email protected] schrieb:
On Nov 14, 10:33 am, newhorizon <[email protected]> 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
GET YOUR BLANK ATM CARD
Get $5,500 USD every day, for six months!
See how it works
Do you know you can hack into any ATM machine with a hacked ATM card??
make up your mind before applying, straight deal…
Order for a blank ATM card now and get millions within a week!: contact me back so we can talk via:
Email: zr16462382130(at)gmail.com
WhatsApp: +1 (415) 510‑0192
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)