set long 9999
set pagesize100
set line222
select dbms_metadata.get_ddl('TABLE','LUCIFER',USER) from dual;

?