(1) To create a new LMT with uniform extents of 32K



SQL> create tablespace users2
  2  datafile 'D:\oracle\oradata3\user2.dbf' size 5M
  3  autoextend off
  4  extent management local uniform size 32k;

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 = 'USERS2';

INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS MIN_EXTLEN STATUS    CONTENTS  LOGGING   EXTENT_MAN ALLOCATIO
-------------- ----------- ----------- ----------- ---------- --------- --------- --------- ---------- ---------
         32768       32768           1  2147483645          0 ONLINE    PERMANENT LOGGING   LOCAL      UNIFORM