To shrink table and its dependant segments,you should use the ALTER TABLE ** SHRINK SPACE CASCADE;statement .Using the CASCADE clause shrinks all the dependant segments of the ** table to release the unused space below and above the High Water Mark(HWM).[@more@]
The table should be located in a tablespace on which automatic segment space management is enabled.If the table is loacted in a tablespace on which manual segment space management is enabled,you cannot shrink the table.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/248644/viewspace-929904/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
