The freeware DDL Wizard makes it easy to reverse engineer the DDL in an
Oracle database. It requires no database access as it simply reads an export file
(created with the ROWS=N option) and extracts the DDL code contained within.
The DDL Extract Wizard is far simpler to use than the dbms_metadata method and works
for export files created by any version of an Oracle database. All DDL in the export file is displayed via an easy to use and intuitive
graphical user interface.
The extracted DDL can be saved to disk as a series of generated SQL scripts which will
rebuild the DDL of the database (or specified schemas). The
DDL2HTML function
can document the DDL in an Oracle database by saving the DDL Code as a
series of interlinked HTML web pages viewable by any web browser software.
Rules can be implemented within the DDL Wizard software which can dynamically
manipulate the extracted DDL code. All optional items on the DDL (such as
storage clauses, tablespace names etc) can be removed or modified. Rules can
be defined to cause global changes across all DDL objects of targeted at
specific DDL objects.
