The Object Extractor allows the retrieval of the DDL text for creating the database objects. You can also retrieve the DDL for the object dependencies ordered by the lowest dependencies first.
The Object Extractor window has the following panes and buttons:
Displays a tree view of all database objects available for extraction.
Displays the list of selected objects to be extracted, duplicate objects cannot be added. A checkbox is available to include extraction of the object’s dependents.
Displays the DDL script when Extract DDL is selected.
Extract the DDL of the selected object(s) to the bottom pane.
Extract the DDL of the selected object(s) directly to a file.
Abort the extraction process.
From the left pane [Select objects to be extracted], select the objects to extract. You can select the user name (all objects belonging to the selected user), object type (all objects of the selected type belonging to the selected object) and a specific object name.
To select the objects for retrieving the DDL, use one of the following
Select the tree node from the left pane and click Add.
Double-click the database object or tree node.
Drag and drop the object over to the right pane [Objects to extract].
By default, all selected objects are extracted with dependents. Deselect the corresponding checkbox if you do not want to include dependents in the [Objects to extract] pane.
To display the DDL script on the bottom pane
Click Extract DDL.
To save the DDL script directly to file
Click Extract to file.
Before the object DDL is extracted, the Extraction Criteria window displays. This window allows you to select how the object DDL displays. If you disable this window, the DDL script is generated according to the selected parameters on the DDL tab in the Preferences window.
To abort the extraction of the DDL