Extract DDL | General
||
|
Note: Preferences preceded by an asterisk (*) are applicable to team coding operations when the Team Coding preference (see Use Extract DDL Preferences) is checked. |
Extract DDL/MetaData
| Option | Description | ||||
|---|---|---|---|---|---|
|
Show this window before performing the task |
Show the preferences before the DDL is extracted from the object. | ||||
|
<schema>, <object> File Name Prefix |
| ||||
|
New tab in the Code Editor for each object |
| ||||
|
Extract DDL to the same tab in the Code Editor |
|
Extract DDL
| Option | Description | ||||
|---|---|---|---|---|---|
| Extract DDL on drag & drop within DB Navigator | Allow drag & drop of the extracted DDL to another database within the same DB Navigator tree. | ||||
| Keywords case | Select the case used for keywords in the DDL. | ||||
| Names case | Select the case used for names in the DDL. | ||||
| Generate comments | Show pre-generated comments in the DDL. Can be helpful to identify different parts of the script. | ||||
| Prefix with Schema name | Any Object Name that is displayed within the DDL is prefixed with the Schema Name. | ||||
|
Include Drop |
Include the drop statement at the beginning of the DDL to drop the object first.
| ||||
| Include "Force" with TYPE DROP | Include Drop with Force in the DLL statement for type objects. | ||||
| Use "CREATE OR REPLACE" | Add Create or Replace to the start of the object, rather than just having Create. | ||||
| Include "Tablespace name" | Include the Tablespace name in the DDL. | ||||
| Include "Storage clause" (Only Non-Default Values for Partitioned Tables)* | Include the Storage clause in the DDL. | ||||
| Include "Physical Attributes Clause"* | Include the Physical Attributes clause in the DDL. | ||||
|
Include "Grants"* |
Include the Grants in the DDL.
| ||||
| Body and Spec for Packages/Objects | Includes DDL for both the body and the specification when extracting from packages or objects. The package specification declares procedures, functions, cursors, and variables. The package body contains the implementation of the public procedures and functions, together with internal and private programs and variables. | ||||
|
Show Trigger Snapshot |
The Oracle Data Dictionary stores the DDL used to create a trigger in the all_triggers_view, along with all the other trigger parameters.
| ||||
|
Separator Character |
Select the character to be used as the separator in the DDL. If you extract DDL for several objects, the DDL for each object will be separated using the selected separator.
| ||||
|
Format Output (will not include Inline Advice) |
Format the DDL according to Formatting Options. Inline advice is never included even if Tools | Formatter Tools | Enable Inline Advice is selected. |