Oracle

Quest Data Modeler supports Oracle as a target database. The following sections list all the supported data types and objects along with the Reverse Engineer and Forward Engineer parameters.

Supported Data types

Numeric

String Literals

Date and Time

Other

  • BINARY_DOUBLE

  • BINARY_FLOAT

  • DEC

  • DEC()

  • DEC(,)

  • DECIMAL

  • DECIMAL()

  • DECIMAL(,)

  • DOUBLE PRECISION

  • REAL

  • FLOAT

  • FLOAT()

  • INT

  • INTEGER

  • NUMBER

  • NUMBER()

  • NUMBER(,)

  • NUMERIC

  • NUMERIC()

  • NUMERIC(,)

  • ROWID

  • SMALLINT

  • CHAR

  • CHAR()

  • CHARVARYING()

  • CHARACTER

  • CHARACTER()

  • CHARACTERVARYING()

  • CLOB

  • DBURITYPE

  • URITYPE

  • HTTPURITYPE

  • JSON

  • JSON()

  • LONG

  • NATIONAL CHAR

  • NATIONAL CHAR VARYING()

  • NATIONAL CHAR()

  • NATIONAL CHARACTER

  • NATIONAL CHARACTER VARYING()

  • NATIONAL CHARACTER()

  • NCHAR

  • NCHAR VARYING()

  • NCHAR()

  • NCLOB

  • NVARCHAR2()

  • UROWID

  • UROWID()

  • VARCHAR()

  • VARCHAR2()

  • XDBURITYPE

  • XMLTYPE

  • DATE

  • INTERVAL DAY TO SECOND

  • INTERVAL YEAR TO MONTH

  • TIMESTAMP

  • TIMESTAMP WITH LOCAL TIMEZONE

  • TIMESTAMP WITH TIMEZONE

  • TIMESTAMP()

  • TIMESTAMP() WITH LOCAL TIMEZONE

  • TIMESTAMP() WITH TIMEZONE

  • JSON

  • ANYDATA

  • ANYDATASET

  • ANYTYPE

  • BFILE

  • BLOB

  • LONGRAW

  • ORDAUDIO

  • ORDDICOM

  • ORDDOC

  • ORDIMAGE

  • ORDVIDEO

  • RAW()

  • SDO_GEOMETRY

  • SDO_GEORASTER

  • SI_AVERAGECOLOR

  • SI_COLOR

  • SI_COLORHISTOGRAM

  • SI_FEATURELIST

  • SI_POSITIONALCOLOR

  • SI_STILLIMAGE

  • SI_TEXTURE

Supported Objects

The following list summarizes the objects supported under Oracle. You can use the Quick Editor to edit any of these object properties. For more information on using the Quick Editor, refer to the Model Properties topic.

Note: You can use the Ctrl+Z and Ctrl+Y keyboard shortcuts to undo and redo changes in any property field.

Annotations

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the annotation  
Type Specifies the type of the annotation Available types include Cross, Diamond, Ellipse, Hexagon, and others.
Physical Only Indicates whether the annotation applies only to the physical model  
Text Editor     Specifies the text in an annotation Use this to add or edit text in an annotation.
Definition     Specifies annotation description or business meaning Use Expand icon which opens definition editor. to open the Definition Editor to edit annotation descriptions. Select Save to apply changes or Cancel to discard them.

Cluster

Tab Section Property Description Additional Information
Properties Properties Name Specifies the name of the cluster  
Owner Specifies the owner of the cluster  
Generate Specifies whether the SQL statement is generated for the cluster during forward engineering  
Index Cluster Index Specifies the index of the Index cluster

 
Hash Cluster Hash Keys Specifies the number of Hash Keys of the Hash cluster  
Single Table Specifies whether the Hash cluster consists of a single table  
Hash Expression Specifies the Hash expression for the Hash cluster  
Common Properties Size Specifies the size of the cluster  
Units Specifies the units of the cluster Drop-down is provided to select a unit
  Cluster Columns Name Specifies the cluster column name  
Physical Data Type Specifies the physical data type for the cluster column  
Sort Column Specifies column sorting  
Storage   Name Specifies the name of the cluster storage  
Options Parallel Mode Use Parallel Specifies whether to use the parallel type processing for the cluster

 
Parallel Specifies parallel processing  
Row Dependencies Specifies whether row dependencies are tracked for the cluster

No Row Dependencies: Generates NOROWDEPENDENCIES. Row-level dependency information is not tracked. This is the default.

Row Dependencies: Generates ROWDEPENDENCIES. Row-level change tracking is stored, which is used in replication and flashback scenarios.
Cache Specifies the cache type for the cluster

No Cache: Generates NOCACHE. Blocks read during a full scan are aged out of the buffer cache quickly. This is the default for clusters.

Cache: Generates CACHE. Retains the data blocks of the cluster in the buffer cache as long as possible.
Index   Name Specifies the name of the index  
Owner Specifies the database owner name for the index  

Databases

Tab Section Property Description Additional Information
General Properties Name Specifies the database name You can change the name in this field.
Generate Specifies that DDL is generated for this object during Forward Engineering If you do not select the check box, no DDL is generated for this object during Forward Engineering.
Database Options Control File Reuse Specifies whether to reuse an existing control file when you create the database The CONTROLFILE REUSE clause in the CREATE DATABASE statement is used if a control file with the specified name already exists when you create the Oracle database.
Max Data Files Specifies a numeric value for this parameter, which affects the control file size The control file size changes between some releases of Oracle, as well as when the number of files specified in the control file changes.
Max Instances Specifies a numeric value for this parameter, which affects the control file size  
Character Set Specifies the character set the database uses to store data The supported character sets and default value of this parameter vary depending on your Oracle version.
National Character Set Specifies the national character set used to store data in columns that are defined as NCHAR, NCLOB, or NVARCHAR2

Valid values: AL16UTF16, UTF8

Default: AL16UTF16
Time Zone Specifies the time zone offset for the database Select the + or – option, and select hours (HH) or minutes (MM). The valid range for UTC format is –12:00 to +14:00.
Storage File Type Specifies whether to use a big or small storage file Use the drop-down to select the storage file type option.
  Logging Logging Options Max Log Files Specifies the maximum number of log files The value must be numeric
Max Log Members Specifies the maximum number of log members The value must be numeric
Max Log History Specifies the maximum log history The value must be numeric
Archive Log Specifies the archive log mode for the database

NOARCHIVELOG: Filled online redo log files are reused without being archived. Point-in-time media recovery is not possible.

ARCHIVELOG: Filled online redo log files are archived before reuse, which supports point-in-time recovery and online backups.
Force Logging Specifies that the database is placed in force logging mode  
Redo Log Members Create Log File Specifies the log file creation  
Group Id Specifies the log group ID  
File Size Specifies the file size for the redo log group  
Reuse File Specifies that an existing log file is reused  
Tablespace Tablespace Options System Oracle Tablespace Specifies the databasename.SYSTEM tablespace for the database This tablespace is created upon database creation and can only be deleted upon database deletion. If you rename the database, this tablespace is also renamed. It cannot be forward engineered. If this tablespace is locally managed, the Default Temporary Tablespace and Default Permanent Tablespace cannot be dictionary managed. Generates the Extent Management Local or the Datafile clause, or both.
Default Tablespace Specifies the default tablespace for the database The list is filtered with the tablespaces only if they exist. Generates the default_tablespace clauses.
Auxiliary Oracle Tablespace Specifies the databasename.AUXILIARY tablespace for the database This tablespace is created upon database creation and can only be deleted upon database deletion. If you rename the database, this tablespace is also renamed. It cannot be forward engineered. Generates the AUXILIARY clause.
Default Temp Tablespace Specifies the default temporary tablespace for the database The list is filtered with temporary tablespaces only if they exist. Generates the default_temp_tablespace clauses.
Undo Tablespace Specifies the undo tablespace for the database The list is filtered with undo tablespaces only if they exist. Generates the undo_tablespace clauses.

Database Links

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the database link You can change the name of the database link in this field.
Physical Name Specifies the physical name of the database link  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Connection Options Shared Specifies a shared connection to the database link When you select this option, an authenticated user is required. Connection Type is automatically selected and unavailable because it cannot be deselected for this option.
Public Specifies a public connection to the database link Select either CURRENT USER or FIXED USER. No user authentication is available for this option. If you do not select either Shared or Public, the database link is considered Private, and no user authentication is available.
Connection Type Specifies the connection type for the database link

CURRENT USER: The default connection type when the Shared option is selected, and one of two connection types available when the Public option is selected. Enter a name in the Authenticated User text box; this option is not available if you selected Public

USER: Available if you selected either Shared or Public. Assigns a fixed user as the connection type. User is required. If you selected Shared, enter a value in the Authenticated User field

AUTHENTICATED USER: Available only if you selected Shared. Enter a name in the Authenticated User text box
User Specifies the user name for the database link  
Password Specifies the password for the database link  
Authenticated User Specifies the authenticated user name for the database link  
Connect String Specifies the connection string for the database link  

Directories

Tab Property Description Additional Information
Properties Name Specifies the name of the directory You can change the name of the directory in this field.
Use Replace Syntax Specifies whether Forward Engineering uses the REPLACE command instead of the CREATE command  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Path Specifies the path (location) of the directory Use the browse button to browse for and select the path for the directory.

Disk Groups

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the disk group You can change the name of the disk group in this field.
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Disk Group Options Redundancy Type Specifies the redundancy type for the disk group

HIGH: Maintains three copies of each extent, so the disk group tolerates the loss of two failure groups.

NORMAL: Maintains two copies of each extent, so the disk group tolerates the loss of one failure group.

EXTERNAL: does not mirror data. Redundancy is provided by the underlying storage subsystem.
Fail Group Name Displays the fail group name that the selected disk group belongs to  

Functions

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the object You can change the object name in this field.
DB Owner Specifies the database owner assigned to the selected procedure or function  
Type Specifies whether the object type is model-level or table-level Select the type from the drop-down list.
Attach To New Specifies that the selected object is attached to each new table that you create Clear the check box if you want to manually attach a stored procedure or function.
Use Replace Syntax Specifies that the stored procedure or function DDL generated during Forward Engineering replaces any occurrence of an identically named object  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Code     Specifies the code (including macros) assigned to a stored procedure or function  
Expanded     Displays the code assigned to a stored procedure or function Code is read-only in this tab.
Alias     Specifies the aliases (synonyms) for the function  
Object Creation Order   Name Specifies the name of the function for the order of DDL generation for the object  
Owner Specifies the owner for the order of DDL generation for the object  
Type Specifies the order type of DDL generation for the object  

Libraries

Tab Section Property Description Additional Information
General Library Options Name Specifies the name of the library You can change the name of the library in this field.
Owner Specifies the database owner assigned to the library  
Use Replace Syntax Specifies whether the library DDL generated during Forward Engineering replaces any occurrence of an identically named library  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
File Name Specifies the file name for the library  
Database-Link Specifies the database link for the library Displays available database links. Use the browse button to add a new database link or edit an existing one.

Packages

Tab Section Property Description Additional Information
Properties Properties Name Specifies the name of the package  
Owner Specifies the database owner assigned to the selected package  
Generate Specifies that DDL is generated for this object during Forward Engineering If you do not select the check box, no DDL is generated for this object during Forward Engineering.
Use Replace Syntax Specifies that the package DDL generated during Forward Engineering replaces any occurrence of an identically named package  
Expanded     Displays expanded code for the package body and specification in read-only format  
Context   Name Specifies the name of the contexts available for the package A context is used to hold application data. You can create more than one context per package. Contexts are supported in Forward Engineering and Reverse Engineering.
Type Specifies the type of the context

 
Use Replace Syntax Specifies that the package DDL generated during Forward Engineering replaces any occurrence of an identically named package  
Generate Specifies that DDL is generated for the context during Forward Engineering  
Object Creation Order     Specifies the order of DDL generation for the package  

Rollback Segments

Tab Section Property Description Additional Information
General   Name Specifies the name of the rollback segments in the current model  
Generate Generates DDL for this object during Forward Engineering If you do not select the check box, no DDL is generated for this object during Forward Engineering.
Public Specifies that the rollback segment is public  
Offline Specifies that the rollback segment is offline  
Storage   Name Specifies the name of rollback segments storage  

Schemas

Tab Section Property Description Additional Information
  General   Schema Properties Name Specifies the name of the schema  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Schema Element Specifies the elements that belong to the schema Use the edit icon to open the editor and define schema elements.

Sequences

Tab Section Property Description Additional Information
Properties General Properties Name Specifies the name of the sequence in the current model  
Owner Specifies the database owner assigned to the selected sequence  
Generate Generates DDL for this object during Forward Engineering If you do not select the check box, no DDL is generated for this object during Forward Engineering.
Schema Properties Starting Value Specifies the starting value of the sequence  
Increment By Specifies the value by which the sequence is incremented  
Cycle Values Specifies the value of the sequence cycles

 
Cache Values Specifies the cache values for the sequence

 
Specify Maximum Value Specifies the maximum value for the sequence  
Specify Minimum Value Specifies the minimum value for the sequence  
Order Values Specifies the order value for the sequence  
Alias   Name Specifies the synonyms for the sequence  

Stored Procedures

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the object You can change the object name in this field.
Owner Specifies the database owner assigned to the selected procedure or function  
Type Specifies whether the object type is model-level or table-level

Select the type from the drop-down list.

Table Type

Model Type
Attach To New Specifies that the selected object is attached to each new table that you create Clear the check box if you want to manually attach a stored procedure or function.
Use Replace Syntax Specifies that the stored procedure or function DDL generated during Forward Engineering replaces any occurrence of an identically named object  
Generate Generates SQL during forward engineering Clear the check box if you do not want to generate SQL.
Code     Specifies the code (including macros) assigned to a stored procedure or function  
Expanded     Displays the code assigned to a stored procedure or function Code is read-only in this tab.
Alias     Specifies the aliases (synonyms) that you can create, edit, or delete for the selected object  
Object Creation Order     Specifies the order of DDL generation for the object  

Synonyms

Tab Section Property Description Additional Information
  Properties   Name Specifies the synonym name  
Physical Name Specifies the synonym physical name  
Generate Generates DDL for this object during Forward Engineering If you do not select the check box, no DDL is generated for this object during Forward Engineering.
Referenced Object Object Owner Specifies the database owner assigned to the selected synonym  
Object Name Specifies the object name of a synonym  
Database Link Specifies the database link of a synonym  
Synonyms Options Public Synonym Specifies that the synonym is a public synonym Every user in the database can access a public synonym.
Alias     Specifies the alias for the synonym  

Tablespaces

Tab Section Property Description Additional Information
Properties   Name Specifies the name orf the tablespace  
Tablespace Set Specifies whether the tablespace is a part of a tablespace set  
Type Specifies the tablespace type

Undo: Indicates that the tablespace manages undo data in case your database runs in automatic undo management mode

Temporary: Indicates that the tablespace holds schema objects only for the duration of the session

Permanent: Indicates that the tablespace holds persistent schema objects
System Type Specifies whether the tablespace is a locally managed system or an auxiliary system tablespace

System

System Auxiliary

Generate Specifies whether a SQL statement for the tablespace is generated during forward engineering  
General Properties Storage File Type Specifies whether the tablespace is a bigfile or smallfile tablespace

Big: Indicates that the tablespace contains only one data file or temp file

Small: Indicates that the tablespace can contain 1022 data files or temp files
Min Extents Specifies the minimum size of an extent in the tablespace Available only when Type is set to Permanent.
Min Extent Data Unit Specifies the data unit of the Min Extents value

Available only when Type is set to Permanent.

Indicates whether the data unit is kilobytes (K), megabytes (M), gigabytes (G), terabytes (T), petabytes (P), or exabytes (E).
Read Only Specifies whether the tablespace is read-only Available only when Type is set to Permanent.
Block Size Specifies a nonstandard block size Available only when Type is set to Permanent.
Data Unit Specifies the data unit of the Block Size value Available only when Type is set to Permanent.
Logging Specifies the logging setting for tables, indexes, materialized views, materialized view logs, and partitions within the tablespace

Available only when Type is set to Permanent.

Logging: Indicates whether the creation of a database object and the subsequent inserts into the object are logged in the redo log file

No Logging: Indicates whether the creation of a database object and the subsequent conventional inserts into the object are logged in the redo log file

File System Like Logging: Indicates whether only metadata changes are logged
Force Logging Specifies whether force logging is enabled for the tablespace and all changes to all objects are logged except temporary segments

Available only when Type is set to Permanent.

This setting overrides the No Logging setting of individual objects.
Table Compression Specifies the default compression for tables within the tablespace Available only when Type is set to Permanent.
Index Compression Specifies the default compression for indexes within the tablespace Available only when Type is set to Permanent.
Offline Specifies whether the tablespace is available for use immediately after its creation Available only when Type is set to Permanent or Undo.
Extent Management Type Specifies the mechanism for managing extents of the tablespace  
Local Extent Management Type Specifies the mechanism for managing local extents of the tablespace  
Extent Management Data Unit Specifies the data units for managing extents of the tablespace  
Segment Management Type Specifies whether the used and free space in the segments in the tablespace is tracked using free lists or bitmaps

Available only when Type is set to Permanent.

Auto: Indicates that bitmaps are used for tracking

Manual: Indicates that free lists are used for tracking
Flashback Mode Specifies whether the tablespace can participate in FLASHBACK DATABASE operations Available only when Type is set to Permanent.
Encryption Algorithm Specifies the encryption algorithm to be used in case the tablespace is encrypted  
Is Encrypted Specifies whether the tablespace is encrypted  
Storage   Name Specifies the tablespace name from the current model to which storage properties are assigned  
File   Name Specifies the name of the file
Dependencies   Name Displays the dependencies of the tablespace  

User Defined Types

Tab Section Property Description Additional Information
Properties Properties Name Specifies the name of the user defined type  
Owner Specifies the database owner  
Generate Specifies whether a SQL statement for the user defined type is generated during forward engineering  
Columns   Name Specifies the name of the user defined type's attribute  
Physical Data Type Specifies the physical data type for the selected column  
Alias   Name Specifies the synonyms that you can add, modify, or delete  

Validation Rules

Tab Section Property Description Additional Information
Properties   Name Specifies the name of the user defined type  
Physical Only Indicates whether the annotation applies only to the physical model  
Type Specifies the type of validation rules

User-Defined

MinMax

Valid Values

Validation_Rule_61' Expression Validation_Rule_61' Expression Specifies the expression for the validation rules  

Views

Tab Section Property Description Additional Information
Properties Properties Name Specifies the physical name of the view  
Owner Specifies the database owner  
Force Create Specifies whether the view is created irrespective of whether the base tables of the view or the referenced object types exist  
View Type Specifies whether the view is an object view or an XML view  
Editionable Specifies whether the view is an editioned or noneditioned object when editioning is enabled  
Editioning Specifies whether the view is a single-table view that selects all rows from the base table and displays a subset of the rows  
Use Replace Syntax Specifies whether the view is recreated if it already exists  
Generate Specifies whether a SQL statement for the view is generated during forward engineering  
General View Properties Default Collation Specifies the default collation for the view  
Bequeath Rights Specifies whether the functions referenced in the view are executed using the view invoker's rights or the view definer's rights

Current_User: Indicates that the functions referenced by the view are executed using invoker's rights

Definer: Indicates that the functions referenced by the view are executed using the view definer's rights
Sharing Specifies how view data is shared

Metadata: Indicates that a metadata link shares the view's metadata and the data is unique to each container

Data: Indicates that a data link shares the view and the data stays same for all the containers in the application container

Extended Data: Indicates that an extended data link shares the view and the data in the application root is the same for all containers in the application container

None: Indicates that the view is not shared
Container_Map Specifies whether the view can be queried using a container map  
Container_Default Specifies whether the view is enabled for the CONTAINERS clause  
Other Properties Create Table As Specifies whether the table should be created based on the results of a SELECT statement  
Select Select Columns and Expressions Columns Name Specifies the name of the view  
Type Specifies the type of view  
Name Specifies the name of the view columns  
Alias Specifies the alias for the selected view column When you click a column name from the View Columns list, it is automatically placed into the Alias field.
Expression Specifies the selected view column expression that you can edit Available only if the selected view column is a user-defined expression.
Type Specifies the select type of the view column New opens the dialog for adding a new view column.
Select Options Select Type Specifies the select type for the view

ALL

DISTINCT

UNIQUE

Restriction Type Specifies the type of restriction for the view

With Check Option: Specifies that a row must satisfy the constraint entered in the Constraint Name box before the row is inserted into or updated in the view

With Read-Only: Specifies that the view is read only

With Cascaded Check Option

With Local Check Option

From Available Tables and Views Name Specifies the name of the tables, and views in your model  
Type Specifies the type of the table or view  
From Name Specifies the name of the tables or views that you selected as a source  
Alias Specifies an alternative name for the selected source in the From list box An alias is typically a new name that is more appropriate in the context of the view.
Type Specifies the type of table or view selected at the sources  
Where Where Where Specifies the condition that you want view rows to satisfy You do not have to enter the WHERE keyword. The text you enter becomes the WHERE clause in the SQL statement.
Group By Group By Specifies the criteria on which you want to group view rows  
Having Having Specifies a search condition that is applied to each row group and filters out row groups that do not match the search condition This entry is optional.
Order Order Specifies the criteria on which you want to sort the rows returned by the view The text you enter becomes the ORDER BY clause in the SQL statement.
Hierarchical Order Start with Condition Specifies the hierarchical order criteria on which you want to sort the rows returned by the view  
No Cycle    
Hierarchical Condition    
  Siblings    
Restriction Clause Restriction    
  Constraint Name    
User Defined SQL     Specifies the user-defined SQL code for the view that you can change  
SQL     Displays the SQL code for the view  
Alias     Specifies the synonyms that you can add, modify, or delete for the view  

For more information on these parameters, see your vendor's SQL documentation. Furthermore, to view the common object properties that are supported in Oracle, refer to the Common Object Properties topic.

RE Parameters

The following sections explain the reverse engineering options for Oracle.

Overview

Parameter

Description

Additional Information
Reverse Engineer Source Specifies whether you want to reverse engineer from a script or database

Database: Indicates that the model is reverse engineered from a database

Script File: Indicates that the model is reverse engineered from a script
Type Specifies the model type for selection Provides option to choose the type of model between Physical or Logical/Physical
Database Specifies a list of supported databases  
Version Specifies the version of the selected database  
Script File Specifies the script file location

This option is available only when Script File is selected as a Reverse engineer source. Click Browse and select a script file from your directory.

Connection

Parameter Description Additional Information
Authentication Specifies the type of authentication to use to establish a connection

Database Authentication: Indicates that database access credentials are used to establish a connection for reverse engineering.
User Name Specifies the user name to access the database Available when Database Authentication is selected.
Password Specifies the password to access the database  
Connection Type

Specifies the type of connection required to connect to the database.

Select the type of connection as JDBC to connect to the database.

Currently, only JDBC is supported.

  
Instance Name

Specifies the JDBC instance to which you want to connect.

Ensure that you have downloaded, saved, and unzipped the cloud wallet file.

For example, the instance name is as follows:

TNS_ADMIN=<Path of unzipped cloud wallet file>

Connection String

Specifies the connection string based on your JDBC instance

This option is available when Connection Method is set to JDBC.

For example, jdbc:oracle:thin:@dbname_medium?

Owners

Parameter

Description
Available Owners Specifies a list of available owners in the databases
Selected Owners Specifies a list of selected owners in the databases for reverse engineering

Tables

Parameter

Description

Additional Information
Available Tables Specifies a list of available tables in the selected databases for reverse engineering To reverse engineer tables on a database, ensure that the CSV Table Filter option is un-checked
Selected Tables Specifies a list of selected tables for reverse engineering  

Material Views

Parameter Description
Available Material Views Displays the available views
Selected Material Views Displays the selected views

Views

Parameter

Description
Available Views Specifies a list of available views
Selected Views Specifies a list of selected views for reverse engineering

Option Set

Parameter

Description

Additional Information
Option Set Specifies the option set template for reverse engineering

Open: Use this option to open a saved XML option set file.

Save: Use this option to save the configured option set.

Save As: Use this option to save an option set either in the model or in the XML format at some external location.

Delete: Use this option to delete an option set.
<Option Set Name> Specifies the objects to be reverse engineered according to the selected option set. You can edit this list.  

FE Parameters

The following sections explain the forward engineering options for Oracle.

Option Selection

Parameter Description Additional Information
Object Type Specifies the type of objects selected for forward engineering.  
Properties Specifies the properties associated with the selected object type.  

Owner Override

Parameter Description Additional Information
Object Name Displays available objects for owner override. Enter an owner name for the Global Override object to override the owner for all the object groups.

The list of available objects is based on the current target server and may include the following object groups: Table, Index, View, Materialized View, Trigger, and so on.
Owner Override Specifies the owner name to override assignments of the owner for that object group  

Object Filter

Parameter Description Additional Information
Object Specifies the selected objects such as tables, documents, user types, and views for the schema generation.  
Select all Indicates selection of all available objects  
Deselect all Indicates removal of selection from all objects  
Invert Selection Indicates reversal of the current selection  
Change display mode Indicates switching between different object display views Logical Names: Indicates that only logical names of the tables are included in the generated schema.

Physical Names: Indicates that only physical names of the tables are included in the generated schema.

Physical Names, show owner: Indicates that physical names and owners of the tables are included in the generated schema.
Full screen Indicates expansion of the object selection panel to full screen  

Preview

Parameter Description Additional Information
Text Displays the schema in the text editor

Commit to Git: Use this option to commit the FE script to a Git repository.

Save: Use this option to save the generated schema.

Find: Use this option to search through the generated schema.

Print: Use this option to print the generated schema.

Copy: Use this option to copy the selected text in the schema.

Replace: Use this option to find and replace text in the generated schema.

Fullscreen : Use this option for full screen mode.

Connection

Parameter Description Additional Information
Authentication Specifies the type of authentication to use to establish a connection

Database Authentication: Indicates that database access credentials are used to establish a connection for reverse engineering.
User Name Specifies the user name to access the database Available when Database Authentication is selected.
Password Specifies the password to access the database  
Connection Type

Specifies the type of connection required to connect to the database.

Select the type of connection as JDBC to connect to the database.

Currently, only JDBC is supported.