This option enables you to define a default value for the "Optional CREATE Clause" property of each object type, which is populated when the object is first created.
The Optional CREATE Clause text is appended to the DDL CREATE statement when the table is generated. An example use of this option is to define default settings for parallelism and logging in an Oracle database—see below for further details.

Tip

This option is only used to set the default optional create clause for new objects. To edit the Optional CREATE Clause of an existing object or edit the clause on a table-by-table basis, go to the object's Properties screen, click the Storage tab and edit the Optional CREATE Clause field.

ORACLE

Oracle's default values are set to NOLOGGING for Load Tables and PARALLEL NOLOGGING for remaining objects.

To edit the default optional create clause for each object, replace the statement on the free text field or click on the ellipsis button.

  • No labels