Databases Reference
In-Depth Information
Figure 10-1.
Choosing the schema for which to generate object-definition scripts
The wizard then lets you choose what types of database objects to include in the script (see Figure
10-2
). Make
sure you select all the object types that are used by the application. Selecting Check All gives you the option of
generating scripts for all objects in the selected schema. At this point you may also decide whether you wish to show
the generated script inline so you can copy and paste it, or save it as a script file to the APEX script repository.
Figure 10-2.
Selecting the object types in the Generate DDL Wizard
The next step of the wizard (see Figure
10-3
) lists all the objects that match the types you selected in the previous
step. You can be as selective as you like about which objects to include. Your particular application may only use a
subset of the objects within a schema, so you only need to choose those when generating the DDL.
Figure 10-3.
Choosing the specific objects in the Generate DDL Wizard
