LOB segments store LOBs & varrays - Oracle Schema

Discussion

• Nirja Shah   -Posted on 25 Sep 15
  - The first extent of any segment requires at least 2 blocks (if FREELIST GROUPS was 0).
  
  - That is, the initial extent size of the segment should be at least 2 blocks.
  
  - LOBs segments are different because they need at least 3 blocks in the first extent.
  
  - If you try to create a LOB segment in a permanent dictionary managed tablespace with initial = 2 blocks, then it still works because it is possible for segments in permanent dictionary-managed tablespaces to override the default storage setting of the tablespaces.
  
  - But if uniform locally managed tablespaces or dictionary managed tablespaces of the temporary type, or locally managed temporary tablespaces have an extent size of 2 blocks, then LOB segments cannot be created in these tablespaces.
  
  - This is because in these tablespace types, extent sizes are fixed and the default storage setting of the tablespaces is not ignored.

➨ Post your comment / Share knowledge