DDL Wizard Frequently Asked Questions

Questions about What DDL Wizard Is and Does
[01.00] Where is the latest version of this FAQ?
[01.01] How about a summary of what DDL Wizard does?
[01.02] Who wrote DDL Wizard and why?
[01.03] How can I contact the publishers of DDL Wizard?
[01.04] I have an idea for a new/better feature - do you want to hear about it?

Version and Operating System Questions

[02.01] What is the current release version of DDL Wizard?
[02.02] What are the PC system requirements for DDL Wizard?
[02.03] What are the server side requirements for DDL Wizard?
[02.04] What server side operating systems does DDL Wizard support?
[02.05] What Oracle database versions does DDL Wizard support?
[02.06] What version of DDL Wizard am I currently using?
[02.07] How can I see or edit my License key?
[02.08] How do I upgrade DDL Wizard?
[02.09] Why did you completely re-write the DDL Wizard?
[02.10] Is there a Unix/Linux version of the DDL Wizard?

'How do I' and 'Can I' Type Questions

[03.01] Why doesn't the DDL Wizard access the database directly instead of reading an export file?
[03.02] Why doesn't the DDL Wizard handle export files containing data?
[03.03] Did the Oracle corporation provide you with details of the export file structure?
[03.04] Why doesn't the DDL Wizard show the full DDL from the SYS and SYSTEM accounts?
[03.05] How can I see DDL such as PUBLIC SYNONYMS or role creation DDL?
[03.06] What differences in functionality are there between the DDL Wizard supported and unsupported versions?
[03.07] I tried reading an export file and I get "Unknown Object" errors?
[03.08] Why not use other tools to generate the DDL rebuild scripts?



Questions about What DDL Wizard Is and Does

[01.00] Where is the latest version of this FAQ?

The latest version of the DDL Wizard FAQ can be found on the DDL Wizard web site at http://www.DDLWizard.com/faq.html
[01.01] How about a summary of what DDL Wizard does?
The basic function of the DDL Wizard is to read Oracle Export files and extract and display the DDL statements contained inside. It is also possible to add global (or individual) rules which manipulate the DDL statements to change optional parameters (storage clauses, database link passwords & etc). The extracted DDL statements can be saved as SQL build scripts or as an HTML tree documenting the schema structure.
[01.02] Who wrote DDL Wizard and why?
The DDL Wizard software is published by Net 2000 Ltd. as a useful companion utility for our database subsetting product DataBee. However, the DDL Wizard is also useful as a standalone product and fulfills a real need in the Oracle database community. Net 2000 Ltd. also publishes other useful software for Oracle databases.

DataBee
Software designed to create a database which is a referentially correct subset of the data in a large Oracle database.
Data Masker
Software which replaces sensitive data in test and development data with realistic looking but false information.
[01.03] How can I contact the publishers of DDL Wizard?
The DDL Wizard is published by Net 2000 Ltd. An email to any of the addresses on the Contact Page will get to us.
[01.04] I have an idea for a new/better feature - do you want to hear about it?
For sure we do. Please E-mail us support@ddlwizard.com.


Version and Operating System Questions

[02.01] What is the current release version of DDL Wizard?
The current production release of the DDL Wizard is v05.01
[02.02] What are the PC system requirements for DDL Wizard?
DDL Wizard works on Windows Windows XP, Vista, Windows 7, Windows 8, Windows 10 and Windows 2008/2012 Server.

There are no really large hardware requirements - any reasonably new 1GHz (or faster) PC with more than 500Mb of memory should be sufficient. A reasonably large monitor is desirable (but not essential) and a screen resolution as small as 1024x768 will work.

The DDL Wizard software itself takes up very little space - 25 Mb of disk space should be more than sufficient. The Oracle Export files it reads can get fairly large. You might need to reserve 50 to 100Mb for them - depending on the number you wish to keep on hand and the size of each one.

The Microsoft .NET v4.0 Framework should be installed on the PC.

Note: The DDL Wizard software does not connect to the Oracle database and has no requirement for SQL*Net or any other network connectivity (including the Internet).

[02.03] What are the server side requirements for DDL Wizard?
None. The DDL Wizard reads Oracle export files that you create. It does not connect to the Oracle server and has no capability of doing so. It is your responsibility to copy, FTP (or otherwise transfer) the export file to the PC so that the DDL Wizard can read it.
[02.04] What server side operating systems does DDL Wizard support?
All of them. The DDL Wizard reads Oracle export files and export files are always server operating system independent.
[02.05] What Oracle database versions does DDL Wizard support?
DDL Wizard can read export files created by all versions of 8, 9, 10, 11, and 12 of the Oracle database server.
[02.06] What version of DDL Wizard am I currently using?
Every copy of DDL Wizard contains version information in the "About DDL Wizard" dialog box. To see this dialog box start the DDL Wizard application and click on the Wizard logo in the upper right hand corner.
[02.07] How can I see or edit my License key?
To view the License Key dialog box press the Registration Key button in the "About DDL Wizard" dialog box. See the FAQ question [02.06] for information on the "About DDL Wizard" dialog box.
[02.08] How do I upgrade DDL Wizard?
Just get the latest version from the web site (http://www.DDLWizard.com) and re-install. You do not need to uninstall first and you can skip as many versions as you wish. Your saved settings and license keys will be preserved.
[02.09] Why did you completely re-write the DDL Wizard?
Well, the user interface in the old version was quite dated and having been written in C++ it was getting increasingly hard to maintain. Simply put, the tools have moved on, and so we re-wrote it in C# and .NET. The functionality is the same, more export file objects are supported and it is now much easier for us to add new features.
[02.10] Is there a Unix/Linux version of the DDL Wizard?
Sorry, there is no Unix or Linux version available yet.



'How do I' and 'Can I' Type Questions

[03.01] Why doesn't the DDL Wizard access the database directly instead of reading an export file?
For speed mostly - reading an export file is much faster. Accessing the DDL from the database is quite slow (at least 10 times slower). Assuming we did write the DDL Wizard to access the database directly you would soon get annoyed at waiting 15 minutes to see the DDL each time you needed it. We would have to offer some sort of "Save Local Copy" functionality in order to speed things up for you. But then if we did that we would just have re-invented the Oracle export file.

Another reason in favor of reading export files rather than direct database access is that many types of DDL components cannot be recreated by looking at the DBA* views. The information simply isn't in there. Sometimes you have to dig around in the %$% tables owned by SYS to rebuild a DDL component. The structure and content of the system tables can and does change from release to release. Directly pulling the DDL from the database means that the idiosyncrasies of each Oracle version and sub version would have to be coped with. The Oracle Export utility already offers implicit support for the database release it is shipped with and writes the DDL out in a fairly consistent internal format.

[03.02] Why doesn't the DDL Wizard handle export files containing data?
The method the Oracle Export utility uses to store the data rows in an export file appears to vary considerably depending on the version and also on the type of data. At the moment, we are not sure that we have isolated all of the variations which would enable us to offer reasonably bug free and comprehensive support for export files containing data. Export files with data are usually too big to be useful and it is easier to generate them with ROWS=N option. We are considering supporting export files containing data in a future release.
[03.03] Did the Oracle corporation provide you with details of the export file structure?
No, but then we never asked them for it either.
[03.04] Why doesn't the DDL Wizard show the full DDL from the SYS and SYSTEM accounts?
Because someone might actually be crazy enough to run it and trash their database. Also, there are hundreds of synonyms, views, packages and procedures and it clutters up the display terribly for no real good reason. Think about it - the SYS level DDL is pretty useless (you create the SYS and SYSTEM account DDL through the Oracle supplied tools). All of the DDL useful to a DBA - roles, user creates, tablespace creates & etc - is stripped out by the DDL Wizard and placed under the PUBLIC pseudo user.
[03.05] How can I see DDL such as PUBLIC SYNONYMS or role creation DDL?
Use the FULL=Y option during the export file create and you will see all of this sort of DDL in the DDL Wizard under the PUBLIC pseudo user.
[03.06] What differences in functionality are there between the DDL Wizard supported and unsupported versions?
None - both versions are fully functional. With a supported version you get support and with the customer version you can specify the content and format of the DDL display headers and HTML output files.
[03.07] I tried reading an export file and I get "Unknown Object" errors?
Please check that, if you transferred the export file you are reading via FTP, you used BINARY mode for the transfer. The Windows default mode (ASCII) corrupts the export files and makes them unreadable.

This is the most common cause of this type of error. If this is not the issue please do let us know and we will progress it further. It may well be some sort of odd Oracle version specific export file variation that we have not seen before. These occasionally pop up - we quickly add support to the DDL Wizard to handle these unknown objects.

[03.08] Why not use other tools to generate the DDL rebuild scripts?
You could do this, and mostly the tools work. However, the DDL Wizard software offers much more than just reproducing the DDL from the database. Yes, you can generate executable scripts but you can also add rules to change the content of the DDL you are running. For example it is a trivial operation to change the tablespace of a table (or all tables) and to place an OR REPLACE clause on all View Creation statements.

The Oracle Export file also functions as a nice archive of the state of the DDL at a point in time. For example, if you have an old export file you can easily get at the source code contents of a package or procedure without actually havving to restore those objects to the database.

In addition, the DDL Wizard can output the the database SQL in the form of the form of a nice browsable HTML documentation tree. Many people find this to be quite useful for documentation purposes.