exporting oracle tables on command line as sql files
You can generate DDL statements using imp/impdp utilities:

imp user/passwd file=export.dmp show=y log=export.sql 2&gt; /dev/null
impdp user/passwd file=DIR:export.expdp sqlfile=DIR:export2.sql


But this method will generate just schema DDL. INSERT statements will not be generated.