USER_TABLESPACES

Description of accessible tablespaces

Columns
   ___________________________
 
   TABLESPACE_NAME
      Tablespace name
   EXTENT_MANAGEMENT
      Extent management tracking: `DICTIONARY` or `LOCAL`
   LOGGING
      Default logging attribute
   CONTENTS
      Tablespace contents: `PERMANENT`, or `TEMPORARY`
   STATUS
      Tablespace status: `ONLINE`, `OFFLINE`, or `READ ONLY`
   MIN_EXTLEN
      Minimum extent size for the tablespace
   PCT_INCREASE
      Default percent increase for extent size
   ALLOCATION_TYPE
      Type of extent allocation in effect for this tablespace
   MAX_EXTENTS
      Default maximum number of extents
   MIN_EXTENTS
      Default minimum number of extents
   INITIAL_EXTENT
      Default initial extent size
   NEXT_EXTENT
      Default incremental extent size

Related Commands:

Simon Sheppard
SS64.com