Home > Data Modeler Dialog Boxes > DDL Generation Options
This dialog box is displayed when you click Generate in the DDL File Editor dialog box. These options control the content to be included in the generated script.
Buttons at the bottom: Design Rules displays the Design Rules dialog box, enabling you to check your current design for any violations of predefined design rules before you generate the DDL. Include Comments causes comments to be included in the statements. Apply Name Substitution causes old name strings to be replaced with new strings as specified in the Name Substitution pane. You can also select Regular DDL, Advanced Interactive DDL, or Advanced CL DDL.
Advanced Interactive DDL and Advanced CL (command-line) DDL create an ODM (Oracle Data Mining) advanced script with support for interactive (SQL*Plus or SQL Developer) or command-line (SQL*Plus only) setting of the following input parameters: start step, stop step, log file, and log level (1,2 or 3). Format for SQL*Plus execution of a resulting Advanced CL DDL script:
SQL> sqlplus user/password@name @script_name start_step stop_step log_file log_level
'Create' Selection
Lets you select types of objects and specific objects for which to generate CREATE statements. You can select Tree View for an expandable display of all available objects, or a tab (Tables, PK and UK Constraints, and so on) for a subset of objects.
'Drop' Selection
Adds DROP statements for objects of the selected types before any CREATE statements, to drop any existing objects with the same name before creating new objects.
You can include drop dependencies to add CASCADE to the DROP statements.
Name Substitution
Lets you specify old strings to be replaced with new strings in object names when the DDL statements are generated.
Selected: Controls whether the item is enforced in the generation process.
Case Sensitive: Controls whether case sensitivity is applied in searching for old strings to be replaced by new strings.
Oracle Errors to Mask
For Advanced DDL only: Specifies any Oracle errors to be ignored during script execution. For the error Number or Type, specify a hyphen and significant digits without leading zeroes; for example, specify -942 for ORA-00942. The error description is informational only and does not affect the script execution.