GENERATE TABLESPACE DDL
select dbms_metadata.get_ddl('TABLESPACE',tablespace_name) from dba_tablespaces;
or
select 'select dbms_metadata.get_ddl(''TABLESPACE'','''||tablespace_name||''') from dual;' from dba_tablespaces;
or
select 'select dbms_metadata.get_ddl(''TABLESPACE'','''||tablespace_name||''') from dual;' from dba_tablespaces;
