Database Reference
In-Depth Information
As shown in
Figure 10-1
, the wizard asks which of the available schemas you'd like
to use as the basis for the generated script.
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 ob-
jects 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.
