set echo off
--
--  tablespaces_show.sql
--
--  Tablespaces - Displays tablespaces info
--
--  Compatability: 8.1.x and above
--
--  Usage: @tablespaces_show
--
--
-- save SQL*Plus settings:
store set savesqlplus_settings.sql replace
-- set SQL*Plus settings:
set linesize 100
set pages 40
col tablespace_name   format a30 head tablespace
col extent_management for A10 head 'extent|management'
col allocation_type   for A10 head 'allocation|type'

select tablespace_name,extent_management,allocation_type,initial_extent,next_extent,min_extlen,contents
from   dba_tablespaces
order by 1;
--
-- restore SQL*Plus settings:
@savesqlplus_settings