(2) To create a new LMT that is SYSTEM managed.



SQL> create tablespace users3
  2  datafile 'D:\oracle\oradata3\users3.dbf' size 5M
  3  autoextend off
  4  extent management local autoallocate;

Tablespace created.

SQL> select initial_extent, next_extent, min_extents, max_extents, pct_increase
  2         min_extlen, status, contents, logging, extent_management, allocation_type
  3  from   dba_tablespaces
  4  where  tablespace_name = 'USERS3';

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MIN_EXTLEN STATUS    CONTENTS  LOGGING   EXTENT_MAN ALLOCATIO
-------------- ----------- ----------- ----------- ---------- --------- --------- --------- ---------- ---------
         65536                       1  2147483645            ONLINE    PERMANENT LOGGING   LOCAL      SYSTEM