DDL for all tablespace in oracle database.

 SQL> select 'create tablespace ' || df.tablespace_name || chr(10)
 || ' datafile ''' || df.file_name || ''' size ' || df.bytes
  2   || decode(autoextensible,'N',null, chr(10) || ' autoextend on maxsize '
 || maxbytes)
 || chr(10)
 || 'default storage ( initial ' || initial_extent
  3    4    5    6   || decode (next_extent, null, null, ' next ' || next_extent )
 || ' minextents ' || min_extents
 || ' maxextents ' ||  decode(max_  7  extents,'2147483645','unlimited',max_extents)
 || ') ;' as TBS_DDL
 from dba_data_files df, dba_tablespaces t
 where df.tablespace_name=t.tablespace_name
/  8    9   10   11   12   13

TBS_DDL
----------------------------------------------------------------------
create tablespace SYSTEM
 datafile '/oradata/vijay/system01.dbf' size 838860800
 autoextend on maxsize 34359721984
default storage ( initial 65536 minextents 1 maxextents unlimited) ;

create tablespace SYSAUX
 datafile '/oradata/vijay/sysaux01.dbf' size 503316480
 autoextend on maxsize 34359721984
default storage ( initial 65536 minextents 1 maxextents unlimited) ;

create tablespace UNDOTBS1
 datafile '/oradata/vijay/undotbs01.dbf' size 62914560
 autoextend on maxsize 34359721984
default storage ( initial 65536 minextents 1 maxextents unlimited) ;

create tablespace USERS
 datafile '/oradata/vijay/users01.dbf' size 5242880
 autoextend on maxsize 34359721984
default storage ( initial 65536 minextents 1 maxextents unlimited) ;