The DDL Wizard Schemas & Objects Tab

The Schemas & Objects Tab provides a useful view of the Schema Objects in an Oracle export file.

The Schemas & Objects tab works in much the same way as the familiar Windows Explorer application. The panel on the left displays the schemas and the DDL object types they contain. The panel on the right displays a list of the DDL objects for the object type selected in the right hand panel. Underneath the right hand panel are buttons used to write the DDL out to disk files (either all or in part) and some other "helper" buttons.

Using The Schemas & Objects Tab

After the export file has been read, the left hand panel will contain the schema (or schemas if there is more than one) in the export file. Each schema will have a schema icon beside it. Double clicking on the schema name will cause it to expand to show the list of DDL object types the schema contains.

Note: If a schema does not contain any DDL objects of that type then the list will not contain a corresponding entry for that type. For example, if a schema does not contain any snapshots then there will be no snapshot object type shown for that schema on the display.

Note: If the SYS or SYSTEM accounts are present in the export file then selected items from those schemas will be collected and placed under the PUBLIC pseudo user. Such items include tablespaces, role and user creation DDL as well as public synonyms and database links. Not all DDL from the SYS or SYSTEM is presented for display. In order to get a full complement of PUBLIC DDL you must use the FULL=Y option during the export file create.

Once the DDL object list for a schema is on the display, a number of options become available:

Clicking on the object type causes a list of the objects of that type to be displayed in the right hand panel.

Double clicking on the object type or clicking on the View icon immediately to the right of the object type causes a display of all selected DDL objects of that object type to be displayed.

The checkbox beside the DDL object type in the left hand panel is used to include or exclude an entire object type during a save of the DDL to disk as .sql or .html files. It overrides, on the object type level, the specific output settings for each object. For example, if you uncheck the box next to the Grants DDL object type then the Grant DDL code will not be included when a HTML tree is created for the schema.

The right hand panel always displays the names of the objects of the DDL object type selected in the left hand panel. Clicking on the View icon immediately to the right of the object name causes the DDL for that specific object to be displayed. The DDL source code is visible in the DDL Source Dialog Box dialog box and a number of options are also offered.

The checkbox beside the DDL object type, in the right hand panel, is used to include or exclude that specific object during a save of the DDL to disk as .sql or .html files. As mentioned above, can be overridden by excluding the entire type from output.

Important Note: Objects unchecked in the right hand panel will not display in the group viewing functions of the left hand panel. In other words, if the object is not checked in the right hand panel it will not display when clicking on the View button in the left hand panel. This enables you to compose a display of the DDL for a group of objects consisting only of those objects you have selected.

What the Buttons do

Output All DDL

This button will launch a wizard (a series of panels) which will guide you through the process of writing out the entire export file DDL to the disk. Each wizard panel will ask a question and present you with an option such as: HTML or SQL output, where to write the files, preferred naming convention etc.

Output All DDL for a <user>

This button performs much the same function as the Output All DDL button but restricts itself to the currently selected schema.

Output All DDL for a <user> for a <type>

This button performs much the same function as the Output All DDL button but restricts itself to the current DDL object type of the selected schema.

Select/Unselect All

The Select/Unselect All button toggles all check boxes in the left hand panel on or off. An unchecked item will not display as part of a group of objects and can be excluded from writes to the disk.