doc Name: defstorg.sql Author: Mark Gurry The following script lists the default storage for each of the tablespaces. # ttitle 'Tablespace Information ' select substr(tablespace_name, 1,18), initial_extent, next_extent, pct_increase from dba_tablespaces order by tablespace_name;