Table Complete description

=== connected as sysdba === 

SQL> 
set pagesize 9000 
set linesize 80 
set long 100000 
-- spool rcindscr.sql 

SELECT dbms_metadata.get_ddl('TABLE','<TABLE_NAME>','<SCHEMA_NAME>') FROM dual; 

Example: SQL> SELECT dbms_metadata.get_ddl('TABLE','OE_ORDER_LINES_ALL','ONT') FROM dual;