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.


[edit] History

LMT tablespaces were introduced in Oracle 8i.

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

[edit] Test

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.

[edit] Conversion between DMT and LMT

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.

[edit] Also see

  • 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 #