7 、shrink table and its dependent segments

yyycxhtx發表於2007-08-01
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部落格 ” ，連結：http://blog.itpub.net/248644/viewspace-929904/，如需轉載，請註明出處，否則將追究法律責任。

相關文章