Toad Data Modeler 8.0 - User Guide

Available Data Providers are:

• Connection via TCP/IP
• Connection via ODBC

Connection via TCP/IP:

Connection via ODBC

See the property Definer on tab What to Generate, under Entities/Triggers, Views, Procedures, Functions.

During reverse engineering, the Definer property is loaded. Nevertheless, if user does not have particular permissions, the generated DDL script with the Definer property would not work. Now it is possible to deselect this property for the DDL script generation.

Entity

External tables

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

Data Types:

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

For User data type, you can define REF options.

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.

Virtual Column

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.

Index

Expression Index

Example of Expression index:

Example: Index properties (for domain index):

XML Index

Trigger

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.

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

See Reverse Engineering - Oracle 21c for more information.