Chat now with support
Chat with Support

SQL Navigator for Oracle 8.1 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Extract DDL | Table/View Specific

| 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.

Extract DDL | Constraints

| Constraints

Constraints

Option Description
Include ON DELETE SET NULL clause Includes the ON DELETE SET NULL clause in the DDL.

Extract DDL | Materialized Views/Snapshots

| Materialized Views/Snapshots

Materialized Views/Snapshots

Option Description
Include BUILD clause Choose the type of build clause used for snapshots.

Extract DDL | Users

| Users

Users

Option Description
Include encrypted password Select to include the user's password (encrypted) in the extract ddl script.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating