Toad Data Modeler 7.3

Available Data Providers are:

Connection via ADO
Native Connection
Connection via TCP/IP

Connection via ADO:

Native Connection:

Connection via TCP/IP

Note:

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

Attribute

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

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.

Reverse Engineering

Available Data Providers are:

Connection via ADO
Native Connection
Connection via TCP/IP

Connection via ADO:

Native Connection:

Connection via TCP/IP

Note:

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

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Toad Data Modeler 7.3 - User Guide

Reverse Engineering

Script Generation

Oracle 11g Release 1

Attribute

Index

Trigger (Entity)

Trigger (View)

Reverse Engineering