This is a quick reference article, to save time looking. Every so often I need to port tables between systems, either different versions, hosts or platforms. Automated tools are faster if one does this routinely; but for singular use, the following allows best control (and lets you adjust the indices etc).

The SQL variables should be replaced with their logical values...


set pages 0
set long 999999
select dbms_metadata.get_ddl('TABLE', '@db', '@table') from dual;

The Oracle suite ships with a lot of tools, one may also use

 exp userid=system file=full_ddl.dmp rows=n


use @db
show create table @table