Chat now with support
Chat with Support

Toad Data Modeler 6.3 - User Guide

Introduction User Interface Models and Model Objects
Physical Data Model
About Physical Data Modeling Benefits of Physical Data Model Entity Relationship Diagram Objects Basic Database Design Advanced Database Design
Universal Data Model Logical Data Model Working with Model Objects Model Properties Model Statistics
Features and Tools
Application Variables Export/Import DDL Script Generation Graphics Model Actions Print Projects Reports Reverse Engineering Scripting and Customization SQL Templates Tips and Tricks Toad for Oracle Integration Toad Intelligence Central (TIC) Integration Tools Version Control
Options and Configuration Databases
Supported Databases Connection Types by Database DB2 UDB v. 8 (LUW) DB2 v. 9 (LUW) DB2 v. 9.5 (LUW) DB2 v. 9.7 (LUW) DB2 v. 10.1 (LUW) DB2 v. 10.5 (LUW) DB2 z/OS v. 9 DB2 z/OS v.10 DB2 z/OS v. 11 Greenplum 4.1 Greenplum 4.2 Ingres 9.3 Ingres 10.0 Microsoft Access 2000/2002/2003 Microsoft Access 2007/2010 Microsoft Azure SQL Database Microsoft Azure SQL Database V12 Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2008 Microsoft SQL Server 2012 Microsoft SQL Server 2014 Microsoft SQL Server 2016 MySQL 5.0 MySQL 5.1 MySQL 5.5 MySQL 5.6 MySQL 5.7 Oracle 9i Oracle 10g Oracle 11g Release 1 Oracle 11g Release 2 Oracle 12c Release 1 Oracle 12c Release 2 PostgreSQL 8.1 PostgreSQL 8.2 PostgreSQL 8.3 PostgreSQL 8.4 PostgreSQL 9.0 PostgreSQL 9.1 PostgreSQL 9.2 PostgreSQL 9.3 PostgreSQL 9.4 PostgreSQL 9.5 SQLite 3.7 Sybase ASE 12.5 Sybase ASE 15 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
Legal Information

Reverse Engineering

Databases > Oracle 10g > Reverse Engineering

See Reverse Engineering - Oracle 9i for more information.

Note:

  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.

Specifics

Databases > Oracle 10g > Specifics

Entity

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.

Attribute

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.

    Index

    Example of Expression index:

    Example: Index properties (for domain index):

     

    Trigger

     

    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

     

    Procedure

     

    Function

    Directory

    Java

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

    Sequence

    Synonym

    Tablespaces

    Script Generation

    Databases > Oracle 10g > 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

    Related Documents

    The document was helpful.

    Select Rating

    I easily found the information I needed.

    Select Rating