DynamicLoadEnable
This attribute enables or disables dynamic load of data from an Oracle database to a TimesTen dynamic cache group. By default, dynamic load of data from an Oracle database is enabled.
To enable or disable dynamic load at the statement level and temporarily override the setting of this attribute, set the DynamicLoadEnable optimizer flag with the ttOptSetFlag built-in procedure or using the statement level optimizer hint TT_DynamicLoadEnable in a SQL statement.
Note:
The value of this attribute overrides the dynamic load behavior of all dynamic cache groups for the current connection to the database.
Required Privilege
No privilege is required to change the value of this attribute.
Setting
Set DynamicLoadEnable as follows:
| Where to set the attribute | How the attribute is represented | Setting |
|---|---|---|
|
C or Java programs or UNIX and Linux systems |
|
|
|
Windows ODBC Data Source Administrator |
Not applicable |