LMT

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

History

LMT tablespaces were introduced in Oracle 8i.

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

Test

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

SQL> SELECT tablespace_name, extent_management FROM dba_tablespaces;

TABLESPACE_NAME                EXTENT_MAN
------------------------------ ----------
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

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

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