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. |
Entity
New combo boxTable Type available in Entity Properties dialog, tab General. When the Typed Tableoption is selected, the new combo boxSelect Composite Type appears below the Table Type combo box.Select Composite Type combo box lists all existing User Data Types.
|
Note: Make sure you select Composite type table from the combo box or run verification, which will return an Error message in case a wrong type is used. |
Key Properties
Options Deferrable and Deferred available on Key Properties dialog, tab General.
Trigger
New Column List box available for trigger event Update (Update checkbox must be selected).
|
Note: Use comma (,) as a separator. |
New When Condition box available on Trigger Properties dialog, tab General.
User Data Type
Enumerated type does not require any Label.
Other objects in Model Explorer:
- Aggregates
- Rewrite Rules
- Sequences
- Tablespaces