Chat now with support
Chat with Support

SQL Navigator for Oracle 7.5 - Installation Notes

Extract DDL | Table/View Specific

Table/View specific

Note: Preferences preceded by an asterisk (*) are applicable to team coding operations when the Team Coding preference (see Use Extract DDL Preferences) is checked.

 

Option Description

Include "Constraints"

* Includes any constraints for the object in the DDL.

Option Description
Disable "Constraints" *Generate DDL with constraints in a disabled state.
Include "Triggers" *Includes any triggers for the object in the DDL.
Include "Indexes" Includes any indexes for the object in the DDL.
Include "Comments" *Includes any comments for the object in the DDL.
Include "Primary Key in Table Definition" Includes the Primary Key for the table in the DDL.
Include "Synonyms" Includes any Synonyms for the object in the DDL.
Exclude Table column default values* *Excludes all default values for the object from the DDL.
Include ENCRYPTION clause Includes any encryption-related clauses (such as encryption algorithm to be used, salting and so forth) for the object in the DDL.
Include FORCE clause Select the measurement unit you want to use for specifying margin width and other print settings.
Include datatype definition for table column Include datatype definition for any columns that are of complex type.
Include Byte/Char for Table Columns Display Byte or Char as length for a column.

Partitioning

Option Description
Include "Storage Clause" for Partitions Includes any Partition settings from the Storage Clause for the object in the DDL.
Include "Storage Clause" for Index Partitions Includes any Index Partition settings from the Storage Clause for the object in the DDL.
Storage Clause Options Include storage clauses with either non-default values or all values in the DDL.
Include "Tablespace Name" for Partitions Includes the Tablespace names any Partition for the object in the DDL.
Include "Tablespace Name" for Index Partitions Includes the Tablespace names in any Indexed Partition for the object in the DDL.

Exclude Partition List for Local Index

Excludes Local Index Partitions for the object in the DDL.

Note: Not applicable when Include "storage Clause" for Index Partitions (above) is selected.

List Individual Hash Partitions
Selected The "individual_hash_partitions" clause will be used.
Not Selected The "hash_partitions_by_quantity" clause will be used.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating