Exadata一体机最佳实践.ppt

. Oracle Database 10g: Administration Workshop II 11-* Shrinking Segments by Using SQL Because a shrink operation may cause ROWIDs to change in heap-organized segments, you must enable row movement on the corresponding segment before executing a shrink operation on that segment. Row movement by default is disabled at segment level. To enable row movement, the ENABLE ROW MOVEMENT clause of the CREATE TABLE or ALTER TABLE command is used. This is illustrated in the first example in the slide. Use the ALTER command to invoke segment shrink on an object. The object’s type can be one of the follo