DDL Wizard – freeware to extract DDL from Export-files (dump-files)

0

Thanks to Mark Rittman’s blog:

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

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.

See: http://www.ddlwizard.com/

Share.

About Author

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director for Fusion Middleware. Consultant, trainer and instructor on diverse areas including Oracle Database (SQL & PLSQL), Service Oriented Architecture, BPM, ADF, Java in various shapes and forms and many other things. Author of the Oracle Press book: Oracle SOA Suite 11g Handbook. Frequent presenter on conferences such as JavaOne, Oracle OpenWorld, ODTUG Kaleidoscope, Devoxx and OBUG. Presenter for Oracle University Celebrity specials.

Comments are closed.