Chat now with support
Chat with Support

Toad Data Modeler 6.5 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Create New Project Reports Reverse Engineering Scripting and Customization About Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Amazon Redshift 1.0 IBM DB2 LUW 9.5 IBM DB2 LUW 9.7 IBM DB2 LUW 10.1 IBM DB2 LUW 10.5 IBM DB2 LUW 11.1 IBM DB2 z/OS 10 IBM DB2 z/OS 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 EDB Postgres Advanced Server 10 Microsoft Access 2007/2010 Microsoft Azure SQL Database V12 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 Microsoft SQL Server 2017 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 Oracle 18c Specifics - Oracle 12c Release 2 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 PostgreSQL 10 SQLite 3.7 Sybase ASE 15.5 Sybase ASE 15.7 SAP ASE 16.0 Sybase IQ 15.2 Sybase SQL Anywhere 11 SAP SQL Anywhere 17 Teradata 13 Vertica Database 8.0
Copyright Legal Notices

Oracle 10g


External tables are supported. On tab Physical Properties, select the External Table (Organization External) checkbox. The External Table Properties tab will occur on the form.


Data Types:

For Char and Varchar2 data types, you can define Column Length in.

For User data type, you can define REF options.

Note: Change for CHAR/BYTE of attributes: Previously, it was necessary to select CHAR or BYTE for Char(x) and Varchar(x) data types of attribute (domain) in Column Length in combo box. Now there is a new item "Default" that is selected by default.

  • Reverse engineering: During RE TDM finds out what is the default item in the Oracle database. Example: BYTE is a default item in Oracle database.
    • Previous behavior: BYTE was loaded for the attribute.
    • Current behavior: “Default” item is shown for the attribute. BYTE will be shown in Model Properties dialog | Database Parameters tab | Length Semantics box (it is not used during script generation).
    • If you want to preserve the previous behavior of TDM, select the "Load CHAR/BYTE to Attributes Regardless Database Default Settings" checkbox in the RE Wizard.

    Used Sequence (trigger) - From this box, you can select a sequence that you want to use for the attribute. (A new trigger will be created in SQL script.)

    Encryption Specification - Here, you can write e.g. USING 'AES192' NO SALT.


    Example of Expression index:

    Example: Index properties (for domain index):




    User Data Type

    When you select Varray Type or Nested Table Type, a new tab displays (Varray Type tab or Nested Table Type tab). There, you can see new boxes where you write appropriate values. Click Create Definition and the definition will be written in the memobox.

    The content of the boxes is not saved and is not used for reverse engineering, script or report generation.

    Hints in memoboxes for User Data Types are shown.

    Other Notes

    • Dictionary types are not supported for Oracle models.
    • User Data Types on user data types in Oracle model.

    Materialized View







    Support for Oracle Java Source, including reverse engineering: All the three types of Java schema objects (SOURCE, CLASS, RESOURCE) should be written to this object. - During reverse engineering only SOURCE types are loaded, and from them only sequences of characters for Java source. Other Java schema objects (CLASS, RESOURCE) are loaded only as a name. Checkbox Generate is unselected for all the Java schema objects (SOURCE, CLASS, RESOURCE).




    Reverse Engineering

    Available Data Providers are:

    • Connection via ADO
    • Native Connection
    • Connection via TCP/IP

    Connection via ADO:

    Native Connection:

    Connection via TCP/IP


    1. If the following error message occurs in the Log area: "Unable to reverse users, roles and permissions. You haven't assigned the SELECT_CATALOG_ROLE role!", it means you have not all the necessary rights to load users, roles and permissions.
    2. To load these items successfully, you need to have the  SELECT_CATALOG_ROLE role assigned or need to set a right for user to SELECT tables DBA_USERS, DBA_ROLES, DBA_ROLE_PRIVS, DBA_TAB_PRIVS.
    • Missing access to system table ALL_TABLES.
    • Missing privilege SELECT on system table ALL_TABLES.

    Note: Connection via TCP/IP does not support Oracle native encryption.

    Script Generation

    What to Generate tab - For Entities and Materialized Views the following checkboxes are available:

    • Physical Properties and Table Properties
    • Materialized View Properties

    Uncheck the Physical Properties checkbox not to generate content of tab Physical Properties of entities and materialized views. (For entities, content of tab External Table Properties will not be generated either.)

    Uncheck the Table Properties/ Materialized View Properties checkbox not to generate the content of these tabs in entity and materialized view dialogs.


    Oracle 11g Release 1


    Virtual Column area - If you want the column to be virtual column, select the Is Virtual Column checkbox and fill out the Expression box (e.g. Attribute2 * Attribute3) and set appropriate data type.




    Trigger (Entity)

    The Trigger Fire box with an item COMPOUND.

    Body of Compound Trigger, including initial key sentence "COMPOUND TRIGGER", should be written on tab SQL.

    From the Trigger Fire box, you can select items COMPOUND or BEFORE or AFTER.


    Trigger (View)

    From the Trigger Fire box, you can select items COMPOUND or INSTEAD OF.

    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating