Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Whats the differences between defragmentation (coalescing) and re-organization (rebuilding, moving)?

April 26, 2017coalescing defragmentation differences moving re-organization rebuilding

0

Posted

Whats the differences between defragmentation (coalescing) and re-organization (rebuilding, moving)?

1 Answer

0

Posted

Defragmentation or coalescing is an in-place data operation that compacts the data file and frees up unused disk space. No additional disk space is required during the compacting process. Oracle8i can defragment indexes in place. Data re-organizations such as rebuilding indexes and moving a table or index requires additional temporary disk space during the re-organization process. These operations essentially make a new copy of the object. After the reorganization is complete, the original object is deleted and its disk space freed up. Oracle8i can re-organization indexes, partitioned indexes, IOTs and partitioned IOTs. Both operations make tables and indexes more contiguous, free up disk space and improve database performance.