Get ddl of all tablespaces - oracle database script

SET heading OFF;


SET echo OFF;


SET pages 999;


SET long 90000;

spool ddl_tablespace.sql
SELECT dbms_metadata.get_ddl('TABLESPACE', tb.tablespace_name)
FROM dba_tablespaces tb;

spool OFF