Post date: Nov 05, 2012 12:54:15 PM
Extracting the DDL from ORACLE 9i and above is relatively easy using the DBMS_METADATA package.
Here's a really nice write up on them.
NOTE: I tried using the oracle exp/imp and expdp/impdp tools to create a parsable text file. But there were some issues with this:
The SHOW file from exp (9i compatible) doesn't encode a return character for lines that are exactly the width of the show file.
The output of the expdp (not 9i compatible) gives better results, but I needed 9i compatibility.