set long 20000 longchunksize 20000 pagesize 0 linesize 1000 feedback off verify off trimspool on
column ddl format a1000
exec dbms_metadata.set_transform_param (dbms_metadata.session_transform, 'SQLTERMINATOR', true);
set long 10000
SELECT DBMS_METADATA.GET_DDL('TABLESPACE',tablespace_name) 
FROM dba_tablespaces
-- where tablespace_name='TSDATA'
;