get oracle DDL

select DBMS_METADATA.GET_DDL('TABLE','USERS','ILPS') from dual;
select DBMS_METADATA.GET_DDL('TABLESPACE','SYSTEM') from dual;