http://code.activestate.com/recipes/tags/oracle/new/2014-02-21T09:18:55-08:00ActiveState Code Recipes2014-02-21T09:18:55-08:00Michal Niklashttp://code.activestate.com/recipes/users/186902/http://code.activestate.com/recipes/576534-dump-oracle-db-schema-to-text/

<p style="color: grey"> Python recipe 576534 by <a href="/recipes/users/186902/">Michal Niklas</a> (<a href="/recipes/tags/database/">database</a>, <a href="/recipes/tags/oracle/">oracle</a>, <a href="/recipes/tags/schema/">schema</a>). Revision 19. </p> <p>Export Oracle schema to text. Usable to compare databases that should be the same</p> <p>Oracle schema info: <a href="http://www.eveandersson.com/writing/data-model-reverse-engineering" rel="nofollow">http://www.eveandersson.com/writing/data-model-reverse-engineering</a></p> <p>With <code>--separate-files</code> can save table information as <code>CREATE TABLE</code> statements and all view/function art objects are in separate files (sometime it is easier to compare directories with files than compare two big files)</p>