From Oracle FAQ
Jump to: navigation, search

LMT (Locally Managed Tablespace) is a type of tablespace where extents are managed in the tablespace's header.


LMT tablespaces were introduced in Oracle 8i.

This is the default when you create tablespaces on Oracle 9i (except for the SYSTEM tablespace).


To see if a tablespaces is defined as locally managed, run:

SQL> SELECT tablespace_name, extent_management FROM dba_tablespaces;

------------------------------ ----------
SYSTEM                         DICTIONARY
SYSAUX                         LOCAL
TEMP                           LOCAL
UNDOTBS02                      LOCAL
RADIUS_DATA                    LOCAL
RADUIS_INDEX                   LOCAL
UNDOTBS03                      LOCAL
STATSPACK                      LOCAL
UNDOTBS1                       LOCAL

9 rows selected.

Conversion between DMT and LMT[edit]

From DMT to LMT:

SQL> exec dbms_space_admin.Tablespace_Migrate_TO_Local('ts1');
PL/SQL procedure successfully completed.

From LMT to DMT:

SQL> exec dbms_space_admin.Tablespace_Migrate_FROM_Local('ts2');
PL/SQL procedure successfully completed.

Also see[edit]

  • DMT - Dictionary Managed Tablespaces
  • ASSM - Automatic Segment Space Management
Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #