-- generate SQL to create a tablespace from existing info

select 'CREATE TABLESPACE '||ts.tablespace_name||'
  DATAFILE '''||df.file_name||''' SIZE '||df.bytes/1024/1024||'M
  DEFAULT STORAGE (INITIAL '||ts.INITIAL_EXTENT/1024||'K NEXT '||ts.NEXT_EXTENT/1024||'K MINEXTENTS '||ts.MIN_EXTENTS||' MAXEXTENTS '||ts.MAX_EXTENTS||' PCTINCREASE '||ts.PCT_INCREASE||');'

  from dba_tablespaces ts, dba_data_files df
  where ts.tablespace_name = 'ACS_INDEX'
  and ts.tablespace_name = df.tablespace_name