SQL> set serveroutput on
SQL> set long 999999
SQL> set feedback off
SQL> spool temp_ddl.sql
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',table_name)
2 FROM DUAL;
SQL> spool off
SQL> set serveroutput on
SQL> set long 999999
SQL> set feedback off
SQL> spool temp_ddl.sql
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE',table_name)
2 FROM DUAL;
SQL> spool off