Ispirer Website Ispirer Toolkit Overview Free Trial

Generation Options

Option name Descriptions
Generate DDL If checked, DDL statement will be created for each table.

If this option is checked, a DDL statement will be created for every table. If not - data import scripts and SQL scripts for the remained objects like views, procedures and etc. will be generated.

This option controls the way identity values are generated in a target Oracle database. This option may be set to the values below:

  • ALWAYS” - values in IDENTITY columns will be generated always automatically. And in table definition will be used “generated always as IDENTITY” option.
  • ON NULL” - values in in IDENTITY columns will be generated only instead of nulls. And in table definition will be used “GENERATED BY DEFAULT ON NULL AS IDENTITY” option.
  • DEFAULT” - values in in IDENTITY columns will be generated by default. And “GENERATED BY DEFAULT AS IDENTITY” will be used in table definition in Oracle.

NOTICE: This option works only for Oracle as a target database.


If you have some additional questions or face some difficulties, please contact our support team and provide a detailed description of your issue: support@ispirer.com