Create Table Facility for Oracle
The Create Table facility (/genSqlcreatetable) is
fully supported.
The Create Table facility generates an SQL script to create tables, indexes, stored package specifications, and stored package bodies. Scripts generated by the Create Table facility are correctly formatted for use with the Oracle utilities SQL*Plus and SQL*DBA.
Note: When generating scripts, you must ensure that the assignment file contains settings that match the DBMS connector version and parameters that will be used for the target database.
Use the following connector options to control whether stored package specifications and bodies are created by the generated scripts:
- disable packages—the generated SQL script does not create stored package specifications and stored package bodies. Use this option when generating SQL scripts for Oracle servers without the Procedural option.
The following settings may also affect the generated SQL commands:
