ITPub博客

首页 > Linux操作系统 > Linux操作系统 > How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINK

How to adjust the high watermark in ORACLE 10g – ALTER TABLE SHRINK

原创 Linux操作系统 作者:zecaro 时间:2011-03-29 10:24:28 0 删除 编辑
描述了 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/

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23650854/viewspace-691189/,如需转载,请注明出处,否则将追究法律责任。

下一篇: strace命令用法
请登录后发表评论 登录
全部评论

注册时间:2010-10-28

  • 博文量
    182
  • 访问量
    348650