How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINK
描述了 ALTER TABLE SHRINK 的具体过程，特点和一些限制。
This statement will procede in two steps:
- The first step makes the segment compact
by moving rows further down to free blocks at the beginning of the segment.
- The second step adjusts the high watermark. For this Oracle needs an exclusive table lock,
but for a very short moment only.
......
链接:http://sysdba.wordpress.com/2006/04/28/how-to-adjust-the-high-watermark-in-oracle-10g-alter-table-shrink/
链接:http://sysdba.wordpress.com/2006/04/28/how-to-adjust-the-high-watermark-in-oracle-10g-alter-table-shrink/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23650854/viewspace-691189/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
