What is the difference between locally managed and dictionary managed tablespaces, and what are the benefits of using a locally managed tablespace?
When Oracle allocates space to a segment (like a table or index), a group of contiguous free blocks called an extent is added to the segment. Metadata regarding extent allocation and unallocated extents are either stored in the data dictionary or in the tablespace itself. Tablespaces that record extent allocation in the dictionary are called dictionary managed tablespaces, and tablespaces that record extent allocation in the tablespace header are called locally managed tablespaces.
Related Questions
- What is the difference between locally managed and dictionary managed tablespaces, and what are the benefits of using a locally managed tablespace?
- What is the difference between a Provisional member and an Active member? Are the benefits the same?
- What is the difference between Society benefits and Signature Gold benefits?
