Answered Questions

  • what is the difference between local managed tablespace & dictionary managed tablespace ?

    jayesh gaikar

    • Nov 6th, 2018

    LMT(Locally Managed Tablespace) :In LMT Extents are managed at the data file level.
    DMT(Dictionary Managed Tabalespace) :Extent management in DMT is maintained and carried out at the data dictionary level.

    Surya

    • Jun 15th, 2017

    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