dbms_metadata, dba_source
–Use DBMS_METADATA, rather than DBA_SOURCE
set pages 0
set long 90000
SELECT substr(DBMS_METADATA.GET_DDL(’TABLESPACE’, tablespace_name),1,255) FROM DBA_tablespaces;
SELECT substr(DBMS_METADATA.GET_DDL(’USER’, username),1,255) FROM DBA_users;