Generating script for Tablespace from current database

Generating script for Tablespace from current database

set trimspool on
set pages 0
spool gentbsp.sql
SELECT 'create tablespace'
||' '||tablespace_name
||' '||'logging'
||' '||'datafile'
||' '||file_name
||' '||'size'||' '||bytes
||' '||'EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO'
FROM Dba_Data_Files
spool off;