title: Oracle DDL export
body: <p>I am trying to recreate an oracle database in an HSQL database.
  this is to enable better unit testing on the local developer systems.</p>
  
  <p>What I need to know is is there anything tool/command I can use in the oracle server/client, that can provide me all the DDL commands for all the objects (tables, synonyms, views etc) in the oracle database.</p>
  
  <p>I am planning to go through the created DDL commands and try to convert these commands into HSQL compatible commands.</p>
  
  <p>Is it possible?</p>
  
  <p>Any suggestions will be welcome.</p>
  
  <p>system information:</p>
  
  <pre><code>Oracle DB: Oracle enterprise server 11g R2. 
  HSQL DB: hsql 2.2.9
  </code></pre>