[ Downloads | Contact Us | Site Map | Other Net 2000 Ltd Software ]

The Oracle Export File DDL Extract Wizard


What Does the DDL Extract Wizard Do?
The DDL Extract Wizard will reverse engineer Oracle Export files and will extract, display and manipulate the DDL CREATE statements contained within. It is read-only on the export files and requires very few resources on a Windows based PC.

Why Do You Want to extract the DDL from Export files?
Generating scripts which will rebuild the DDL structure of a database is a common Oracle database maintenance problem. The DDL Extract Wizard is far quicker and easier than a dbms_metadata script and works on export files created by any version of the Oracle database. Simply create an export file, use the DDL Extract Wizard to read it, and the generated DDL scripts are immediately available without the need to write complex code.

How much does the DDL Extract Wizard Cost?
The unsupported version is free of charge. You can purchase a supported version and also custom versions if you wish - but there is no requirement to do so.

A short summary of the many useful things you can do with the DDL Extract Wizard can be found on the Quick Info page. We get lots of feedback on the DDL Extract Wizard - here are some of the nice things people have said. You might also be interested to know our reasons for making the DDL Extract Wizard available for free.

Download the DDL Extract Wizard software [view download page]
A complete, fully functional copy of the DDL Extract Wizard software is available for download.

Summary

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. .