title: generate "create tablespace" script without dbms_metadata.get_ddl
body: <p>i want to create a "create tablespace"-script for from our production database. i already tried the following which leads to a ORA-31603:</p>
  
  <p><code>select dbms_metadata.get_ddl('TABLESPACE',tablespace_name)  from dba_tablespaces where tablespace_name != 'SYSTEM'</code> </p>
  
  <p>After googling i found that i need the <code>SELECT_CATALOG_ROLE</code> to use <code>dbms_metadata.get_ddl</code>. What i have is access to <code>DBA_TABLESPACES</code>. </p>
  
  <p>Question: Is there a way to generate a "create tablespace"-script without the <code>SELECT_CATALOG_ROLE</code> using only <code>DBA_TABLESPACES</code>? </p>
  
  <p>I would write the script on my own but i dont really know how to interpret the information given by <code>select * from DBA_TABLESPACES</code> (is AUOTEXTEND ON or OFF, how much is the initial SIZE and so on...). </p>